APPS.JA_JAINSTAC_XMLP_PKG dependencies on HR_ORGANIZATION_UNITS

Line 379: HR_ORGANIZATION_UNITS

375: SELECT
376: NAME
377: INTO V_NAME
378: FROM
379: HR_ORGANIZATION_UNITS
380: WHERE NVL(ORGANIZATION_ID
381: ,0) = NVL(ORG_ID
382: ,0);
383: RETURN (V_NAME);

Line 397: HR_ORGANIZATION_UNITS

393: CURSOR FOR_LOCATION IS
394: SELECT
395: LOCATION_ID
396: FROM
397: HR_ORGANIZATION_UNITS
398: WHERE ORGANIZATION_ID = ORG_ID;
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