APPS.JA_JAINSTAC_XMLP_PKG dependencies on HR_LOCATIONS

Line 403: HR_LOCATIONS

399: CURSOR FOR_ADDRESS IS
400: SELECT
401: ADDRESS_LINE_1 || ',' || ADDRESS_LINE_2 || ',' || ADDRESS_LINE_3 || ',' || TOWN_OR_CITY || ',' || COUNTRY || ',' || POSTAL_CODE || ',' || TELEPHONE_NUMBER_1 || ',' || TELEPHONE_NUMBER_2 || ',' || TELEPHONE_NUMBER_3
402: FROM
403: HR_LOCATIONS
404: WHERE LOCATION_ID = V_LOCATION_ID;
405: BEGIN
406: OPEN FOR_LOCATION;
407: FETCH FOR_LOCATION