DBA Data[Home] [Help]

APPS.PAY_AU_PAYSLIP_ARCHIVE dependencies on HR_ORGANIZATION_INFORMATION

Line 1508: , hr_organization_information org

1504: ) is
1505: select org.org_information12 abn
1506: from per_assignments_f paaf
1507: , hr_soft_coding_keyflex flex
1508: , hr_organization_information org
1509: where paaf.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
1510: and to_char(org.organization_id) = flex.segment1
1511: and org.org_information_context = 'AU_LEGAL_EMPLOYER'
1512: and paaf.assignment_id = p_assignment_id