APPS.PAY_NL_PAYSLIP_ARCHIVE dependencies on HR_ALL_ORGANIZATION_UNITS

Line 589: FROM hr_all_organization_units hou

585: ) IS
586: SELECT hoi_tax.organization_id org_id
587: ,hou1.name tax_office_name
588: ,hoi_tax.org_information4 reg_no
589: FROM hr_all_organization_units hou
590: ,hr_all_organization_units hou1
591: ,hr_organization_information hoi
592: ,hr_organization_information hoi_tax
593: WHERE hoi.org_information_context = 'CLASS'

Line 590: ,hr_all_organization_units hou1

586: SELECT hoi_tax.organization_id org_id
587: ,hou1.name tax_office_name
588: ,hoi_tax.org_information4 reg_no
589: FROM hr_all_organization_units hou
590: ,hr_all_organization_units hou1
591: ,hr_organization_information hoi
592: ,hr_organization_information hoi_tax
593: WHERE hoi.org_information_context = 'CLASS'
594: AND hoi.org_information1 = 'HR_ORG'

Line 1553: FROM HR_ALL_ORGANIZATION_UNITS hr_org

1549: ,hr_loc.town_or_city city
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

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 (+)