APPS.PQH_BDGT_ACTUAL_CMMTMNT_PKG dependencies on PAY_RUN_RESULT_VALUES

Line 779: PAY_INPUT_VALUES_F INV,PAY_RUN_RESULT_VALUES RRV,

775: Cursor csr_assg_actuals1(p_element_type_id number) IS
776: SELECT max(aa.end_Date) last_payroll_dt, sum(RRV.RESULT_VALUE * get_factor(aa.start_date, aa.end_date,
777: greatest(p_actuals_start_date,aa.start_date), least(p_actuals_end_date,aa.end_date))) result_value
778: FROM
779: PAY_INPUT_VALUES_F INV,PAY_RUN_RESULT_VALUES RRV,
780: PAY_ELEMENT_TYPES_F PET,
781: PAY_RUN_RESULTS RES,
782: (
783: Select tp.start_date, tp.end_date, aac.assignment_action_id

Line 817: PAY_INPUT_VALUES_F INV,PAY_RUN_RESULT_VALUES RRV,

813: Cursor csr_assg_actuals2 IS
814: SELECT max(aa.end_Date) last_payroll_dt, sum(RRV.RESULT_VALUE * get_factor(aa.start_date, aa.end_date,
815: greatest(p_actuals_start_date,aa.start_date), least(p_actuals_end_date,aa.end_date))) result_value
816: FROM
817: PAY_INPUT_VALUES_F INV,PAY_RUN_RESULT_VALUES RRV,
818: PAY_ELEMENT_TYPES_F PET,
819: PAY_RUN_RESULTS RES,
820: (
821: Select tp.start_date, tp.end_date, aac.assignment_action_id

Line 853: l_result_value pay_run_result_values.result_value%type;

849: l_from_period_start_dt date;
850: l_from_period_end_dt date;
851: l_to_period_start_dt date;
852: l_to_period_end_dt date;
853: l_result_value pay_run_result_values.result_value%type;
854: l_element_type_id pay_run_results.element_type_id%type;
855:
856: l_converted_amt number;
857: l_assignment_actuals number;

Line 926: PAY_INPUT_VALUES_F INV,PAY_RUN_RESULT_VALUES RRV,

922: Cursor csr_assg_actuals(p_element_type_id number) IS
923: SELECT max(aa.end_Date) last_payroll_dt, sum(RRV.RESULT_VALUE * get_factor(aa.start_date, aa.end_date,
924: greatest(p_actuals_start_date,aa.start_date), least(p_actuals_end_date,aa.end_date))) result_value
925: FROM
926: PAY_INPUT_VALUES_F INV,PAY_RUN_RESULT_VALUES RRV,
927: PAY_ELEMENT_TYPES_F PET,
928: PAY_RUN_RESULTS RES,
929: (
930: Select tp.start_date, tp.end_date, aac.assignment_action_id

Line 959: l_result_value pay_run_result_values.result_value%type;

955: l_from_period_start_dt date;
956: l_from_period_end_dt date;
957: l_to_period_start_dt date;
958: l_to_period_end_dt date;
959: l_result_value pay_run_result_values.result_value%type;
960: l_element_type_id pay_run_results.element_type_id%type;
961:
962: l_converted_amt number;
963: l_assignment_actuals number;

Line 1285: PAY_INPUT_VALUES_F INV,PAY_RUN_RESULT_VALUES RRV,

1281: Cursor csr_assg_actuals1(p_start_date DATE ,p_assignment_action_id NUMBER,
1282: p_element_type_id number) IS
1283: SELECT sum(RRV.RESULT_VALUE) result_value
1284: FROM
1285: PAY_INPUT_VALUES_F INV,PAY_RUN_RESULT_VALUES RRV,
1286: PAY_ELEMENT_TYPES_F PET,
1287: PAY_RUN_RESULTS RES
1288: WHERE RES.ASSIGNMENT_ACTION_ID = p_assignment_action_id
1289: AND RES.STATUS IN ( 'P','PA' )

Line 1304: PAY_INPUT_VALUES_F INV,PAY_RUN_RESULT_VALUES RRV,

1300: --
1301: Cursor csr_assg_actuals2(p_start_date DATE ,p_assignment_action_id NUMBER) IS
1302: SELECT sum(RRV.RESULT_VALUE) result_value
1303: FROM
1304: PAY_INPUT_VALUES_F INV,PAY_RUN_RESULT_VALUES RRV,
1305: PAY_ELEMENT_TYPES_F PET,
1306: PAY_RUN_RESULTS RES
1307: WHERE RES.ASSIGNMENT_ACTION_ID = p_assignment_action_id
1308: AND RES.STATUS IN ( 'P','PA' )

Line 1345: l_result_value pay_run_result_values.result_value%type;

1341: l_from_period_end_dt date;
1342: l_to_period_start_dt date;
1343: l_to_period_end_dt date;
1344: --
1345: l_result_value pay_run_result_values.result_value%type;
1346: l_element_type_id pay_run_results.element_type_id%type;
1347: --
1348:
1349: l_converted_amt number;

Line 4151: l_result_value pay_run_result_values.result_value%type;

4147: l_from_period_end_dt date;
4148: l_to_period_start_dt date;
4149: l_to_period_end_dt date;
4150: --
4151: l_result_value pay_run_result_values.result_value%type;
4152: l_element_type_id pay_run_results.element_type_id%type;
4153: --
4154:
4155: l_converted_amt number;