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_INPUT_VALUES_F

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 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 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 4075: PAY_INPUT_VALUES_F INV,

4071: pay_payroll_actions ppa,
4072: PAY_ASSIGNMENT_ACTIONS AAC,
4073: PAY_COSTS pc,
4074: PAY_ELEMENT_TYPES_F PET,
4075: PAY_INPUT_VALUES_F INV,
4076: pqh_bdgt_cmmtmnt_elmnts pbce
4077: Where PPA.PAYROLL_ACTION_ID = AAC.PAYROLL_ACTION_ID
4078: AND PPA.PAYROLL_ID = A.PAYROLL_ID
4079: AND ppa.action_type IN ('Q','R','V','B')

Line 4131: PAY_INPUT_VALUES_F INV

4127: pay_payroll_actions ppa,
4128: PAY_ASSIGNMENT_ACTIONS AAC,
4129: PAY_COSTS pc,
4130: PAY_ELEMENT_TYPES_F PET,
4131: PAY_INPUT_VALUES_F INV
4132: Where PPA.PAYROLL_ACTION_ID = AAC.PAYROLL_ACTION_ID
4133: AND PPA.PAYROLL_ID = A.PAYROLL_ID
4134: AND ppa.action_type IN ('Q','R','V','B')
4135: AND ppa.date_earned BETWEEN p_actuals_start_date AND p_actuals_end_date