HRMSi - Employee Budget Status: Grade Budget

Description
Categories: Discoverer
Compares actual and budget values by organization, job, grade and position
Owner: SYSADMIN (System Administrator)
Identifier: HRIAOBPC
SELECT  (NVL(HRI_OLTP_DISC_WRKFRC.GET_FF_ACTUAL_VALUE_PQH(o101926.BUDGET_ID,o101926.BUSINESS_GROUP_ID,o101926.GRADE_ID,o101926.JOB_ID,o101926.ORGANIZATION_ID,o101926.POSITION_ID,:effective_date,o101926.BUDGET_UNIT_CD),0) )-NVL(o101926.BUDGET_PERIOD_BUDGETED_VALUE,0) as C_2,NVL(HRI_OLTP_DISC_WRKFRC.GET_FF_ACTUAL_VALUE_PQH(o101926.BUDGET_ID,o101926.BUSINESS_GROUP_ID,o101926.GRADE_ID,o101926.JOB_ID,o101926.ORGANIZATION_ID,o101926.POSITION_ID,:effective_date,o101926.BUDGET_UNIT_CD),0) as C_1,DECODE(o101926.BUDGET_PERIOD_BUDGETED_VALUE,0,to_number(NULL),NULL,to_number(NULL),(o101926.CALC_PERIOD_ACTUAL_VALUE-o101926.BUDGET_PERIOD_BUDGETED_VALUE )/o101926.BUDGET_PERIOD_BUDGETED_VALUE) as C_3,o101926.BUDGET_MEASUREMENT_TYPE as Effective_start_date,o101926.BUDGET_NAME as Competency_effective_start_dat,o101926.BUDGET_PERIOD_BUDGETED_VALUE as Disabled_effective_start_date,o101926.BUDGET_PERIOD_NAME as Enrolled_in_another_plan_effec,o101926.BUDGET_VERSION_NUMBER as Person_communication_to_be_pro,o101926.BUSINESS_GROUP_NAME as Email_Address,o101926.GRADE_NAME as Party_Id,o101926.JOB_NAME as Position_Id,o101926.ORGANIZATION_NAME,o101926.POSITION_NAME
 FROM HRFG_WORKFORCE_BUDGETS o101926
 WHERE 1=1 AND  (:effective_date BETWEEN o101926.BUDGET_PERIOD_START_DATE AND o101926.BUDGET_PERIOD_END_DATE) 
   AND o101926.BUDGETED_ENTITY_CD = 'GRADE'