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.PAY_PAYROLL_XML_EXTRACT_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 239: pay_payroll_actions ppa_chk

235: FROM pay_assignment_actions paa_xfr,
236: pay_action_interlocks pai_xfr,
237: pay_action_interlocks pai_chk,
238: pay_assignment_actions paa_chk,
239: pay_payroll_actions ppa_chk
240: WHERE paa_xfr.assignment_action_id = pai_xfr.locking_action_id
241: AND pai_xfr.locked_action_id = pai_chk.locked_action_id
242: AND pai_chk.locking_action_id = paa_chk.assignment_action_id
243: AND paa_chk.payroll_action_id = ppa_chk.payroll_action_id

Line 539: pay_payroll_actions ppa,

535:
536: CURSOR get_leg_code IS
537: SELECT hoi2.org_information9
538: FROM pay_assignment_actions paa,
539: pay_payroll_actions ppa,
540: hr_organization_units hou,
541: hr_organization_information hoi1,
542: hr_organization_information hoi2
543: WHERE paa.payroll_action_id = ppa.payroll_action_id

Line 582: FROM pay_payroll_actions ppa,

578:
579: /*14105250 -- Start*/
580: CURSOR c_bgid (cp_assgn_action_id in number) is
581: SELECT business_group_id
582: FROM pay_payroll_actions ppa,
583: pay_assignment_actions paa
584: WHERE
585: paa.payroll_action_id = ppa.payroll_action_id
586: AND paa.assignment_action_id=cp_assgn_action_id;

Line 1294: pay_payroll_actions ppa,

1290:
1291: CURSOR get_leg_code IS
1292: SELECT hoi2.org_information9
1293: FROM pay_assignment_actions paa,
1294: pay_payroll_actions ppa,
1295: hr_organization_units hou,
1296: hr_organization_information hoi1,
1297: hr_organization_information hoi2
1298: WHERE paa.payroll_action_id = ppa.payroll_action_id