APPS.JA_JAINCTRB_XMLP_PKG dependencies on HR_LOCATIONS

Line 448: HR_LOCATIONS

444: CURSOR FOR_ADDRESS IS
445: SELECT
446: ADDRESS_LINE_1 || ',' || ADDRESS_LINE_2 || ',' || ADDRESS_LINE_3 || ',' || TOWN_OR_CITY || ',' || COUNTRY || ',' || POSTAL_CODE || ',' || TELEPHONE_NUMBER_1 || ',' || TELEPHONE_NUMBER_2 || ',' || TELEPHONE_NUMBER_3
447: FROM
448: HR_LOCATIONS
449: WHERE LOCATION_ID = V_LOCATION_ID;
450: BEGIN
451: OPEN FOR_LOCATION;
452: FETCH FOR_LOCATION