APPS.JA_JAINITCR_XMLP_PKG dependencies on HR_LOCATIONS

Line 225: HR_LOCATIONS LOC

221: ,LOC.ADDRESS_LINE_1 || ',' || LOC.ADDRESS_LINE_2 || ',' || LOC.ADDRESS_LINE_3 || ',' || LOC.TOWN_OR_CITY || ',' || LOC.POSTAL_CODE || ',' || LOC.COUNTRY)
222: INTO V_ADDRESS1
223: FROM
224: HR_ORGANIZATION_UNITS HOU,
225: HR_LOCATIONS LOC
226: WHERE HOU.ORGANIZATION_ID = P_ORGANIZATION_ID
227: AND HOU.LOCATION_ID = loc.location_id (+);
228: RETURN (V_ADDRESS1);
229: EXCEPTION