APPS.JA_JAINPRRG_XMLP_PKG dependencies on HR_ORGANIZATION_UNITS

Line 31: HR_ORGANIZATION_UNITS

27: SELECT
28: NAME,
29: LOCATION_ID
30: FROM
31: HR_ORGANIZATION_UNITS
32: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID;
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