DBA Data[Home] [Help]

APPS.PAY_PAYROLL_XML_EXTRACT_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 208: pay_payroll_actions ppa_chk

204: FROM pay_assignment_actions paa_xfr,
205: pay_action_interlocks pai_xfr,
206: pay_action_interlocks pai_chk,
207: pay_assignment_actions paa_chk,
208: pay_payroll_actions ppa_chk
209: WHERE paa_xfr.assignment_action_id = pai_xfr.locking_action_id
210: AND pai_xfr.locked_action_id = pai_chk.locked_action_id
211: AND pai_chk.locking_action_id = paa_chk.assignment_action_id
212: AND paa_chk.payroll_action_id = ppa_chk.payroll_action_id

Line 478: pay_payroll_actions ppa,

474:
475: CURSOR get_leg_code IS
476: SELECT hoi2.org_information9
477: FROM pay_assignment_actions paa,
478: pay_payroll_actions ppa,
479: hr_organization_units hou,
480: hr_organization_information hoi1,
481: hr_organization_information hoi2
482: WHERE paa.payroll_action_id = ppa.payroll_action_id