DBA Data[Home] [Help]

APPS.PAY_PAYROLL_XML_EXTRACT_PKG dependencies on HR_ORGANIZATION_UNITS

Line 540: hr_organization_units hou,

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
544: AND ppa.business_group_id = hou.organization_id

Line 1295: hr_organization_units hou,

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
1299: AND ppa.business_group_id = hou.organization_id