APPS.PO_CHVPRSCH_XMLP_PKG dependencies on HR_LOCATIONS_ALL

Line 76: FROM hr_locations_all LOC,

72: LOC.REGION_2||decode(LOC.REGION_2, null, null,', ')||
73: LOC.COUNTRY||decode(LOC.COUNTRY, null, null,', ')||
74: LOC.POSTAL_CODE
75: INTO x_address
76: FROM hr_locations_all LOC,
77: hr_organization_units UNITS
78: WHERE
79: UNITS.LOCATION_ID = LOC.LOCATION_ID AND
80: organization_id = UNITS.ORGANIZATION_ID;