DBA Data[Home] [Help]

APPS.PAY_NL_PAYSLIP_ARCHIVE dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 1554: ,HR_ALL_ORGANIZATION_UNITS_TL hr_org_tl

1550: ,hr_loc.region_2 province
1551: ,hr_loc.country country
1552: ,hr_loc.region_3 po_box_no
1553: FROM HR_ALL_ORGANIZATION_UNITS hr_org
1554: ,HR_ALL_ORGANIZATION_UNITS_TL hr_org_tl
1555: ,hr_locations_all hr_loc
1556: WHERE hr_org.organization_id = p_organization_id
1557: AND hr_org.organization_id = hr_org_tl.organization_id
1558: AND hr_org.location_id = hr_loc.location_id (+)