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 1282: PAY_INPUT_VALUES_F INV,PAY_RUN_RESULT_VALUES RRV,

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

Line 1301: PAY_INPUT_VALUES_F INV,PAY_RUN_RESULT_VALUES RRV,

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

Line 1342: l_result_value pay_run_result_values.result_value%type;

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

Line 4148: l_result_value pay_run_result_values.result_value%type;

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