DBA Data[Home] [Help]

APPS.PAY_PAYROLL_XML_EXTRACT_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 480: hr_organization_information hoi1,

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

Line 481: hr_organization_information hoi2

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
483: AND ppa.business_group_id = hou.organization_id
484: AND hou.organization_id = hoi1.organization_id
485: AND hoi1.organization_id = hoi2.organization_id