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_ELEMENT_TYPES_F

Line 416: Select null From pay_element_types_f

412: PROCEDURE Validate_element_type(p_element_type_id in number)
413: is
414: --
415: Cursor csr_elmnt_type is
416: Select null From pay_element_types_f
417: Where element_type_id = p_element_type_id;
418: --
419: l_dummy varchar2(1);
420: l_proc varchar2(72) := g_package ||'Validate_element_type';

Line 780: PAY_ELEMENT_TYPES_F PET,

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

Line 818: PAY_ELEMENT_TYPES_F PET,

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

Line 927: PAY_ELEMENT_TYPES_F PET,

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

Line 1283: PAY_ELEMENT_TYPES_F PET,

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

Line 1302: PAY_ELEMENT_TYPES_F PET,

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' )
1306: AND PET.CLASSIFICATION_ID = cl_id

Line 4071: PAY_ELEMENT_TYPES_F PET,

4067: ) a,
4068: pay_payroll_actions ppa,
4069: PAY_ASSIGNMENT_ACTIONS AAC,
4070: PAY_COSTS pc,
4071: PAY_ELEMENT_TYPES_F PET,
4072: PAY_INPUT_VALUES_F INV,
4073: pqh_bdgt_cmmtmnt_elmnts pbce
4074: Where PPA.PAYROLL_ACTION_ID = AAC.PAYROLL_ACTION_ID
4075: AND PPA.PAYROLL_ID = A.PAYROLL_ID

Line 4127: PAY_ELEMENT_TYPES_F PET,

4123: ) a,
4124: pay_payroll_actions ppa,
4125: PAY_ASSIGNMENT_ACTIONS AAC,
4126: PAY_COSTS pc,
4127: PAY_ELEMENT_TYPES_F PET,
4128: PAY_INPUT_VALUES_F INV
4129: Where PPA.PAYROLL_ACTION_ID = AAC.PAYROLL_ACTION_ID
4130: AND PPA.PAYROLL_ID = A.PAYROLL_ID
4131: AND ppa.action_type IN ('Q','R','V','B')