DBA Data[Home] [Help]

APPS.PAY_AU_PAYSLIP_ARCHIVE dependencies on HR_ORGANIZATION_INFORMATION

Line 1343: , hr_organization_information org

1339: ) is
1340: select org.org_information12 abn
1341: from per_assignments_f paaf
1342: , hr_soft_coding_keyflex flex
1343: , hr_organization_information org
1344: where paaf.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
1345: and to_char(org.organization_id) = flex.segment1
1346: and org.org_information_context = 'AU_LEGAL_EMPLOYER'
1347: and paaf.assignment_id = p_assignment_id