eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_BDGT_ACTUAL_CMMTMNT_PKG dependencies on PAY_RUN_RESULTS

Line 781: PAY_RUN_RESULTS RES,

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
784: From per_time_periods tp,
785: pay_payroll_actions ppa,

Line 819: PAY_RUN_RESULTS RES,

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
822: From per_time_periods tp,
823: pay_payroll_actions ppa,

Line 854: l_element_type_id pay_run_results.element_type_id%type;

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;
858: l_proc varchar2(72) := g_package ||'get_sum_actuals';

Line 928: PAY_RUN_RESULTS RES,

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
931: From per_time_periods tp,
932: pay_payroll_actions ppa,

Line 960: l_element_type_id pay_run_results.element_type_id%type;

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;
964: l_proc varchar2(72) := g_package ||'get_element_actuals';

Line 1284: PAY_RUN_RESULTS RES

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' )
1287: AND PET.CLASSIFICATION_ID = cl_id
1288: AND PET.ELEMENT_TYPE_ID = p_element_type_id

Line 1303: PAY_RUN_RESULTS RES

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' )
1306: AND PET.CLASSIFICATION_ID = cl_id
1307: AND p_start_date BETWEEN PET.EFFECTIVE_START_DATE AND PET.EFFECTIVE_END_DATE

Line 1343: l_element_type_id pay_run_results.element_type_id%type;

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;
1347: l_assignment_actuals number;

Line 4149: l_element_type_id pay_run_results.element_type_id%type;

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;
4153: l_position_actuals number;