APPS.JA_JAINPRRG_XMLP_PKG dependencies on HR_LOCATIONS

Line 37: HR_LOCATIONS

33: CURSOR C_ADDRESS(P_LOCATION_ID IN NUMBER) IS
34: SELECT
35: ADDRESS_LINE_1 || ',' || ADDRESS_LINE_2 || ',' || ADDRESS_LINE_3 || ',' || TOWN_OR_CITY || ',' || COUNTRY || ',' || POSTAL_CODE || ',' || TELEPHONE_NUMBER_1 || ',' || TELEPHONE_NUMBER_2 || ',' || TELEPHONE_NUMBER_3
36: FROM
37: HR_LOCATIONS
38: WHERE LOCATION_ID = P_LOCATION_ID;
39: CURSOR C_SOB_ID(P_ORG_ID IN NUMBER) IS
40: SELECT
41: TO_NUMBER(SET_OF_BOOKS_ID)