DBA Data[Home] [Help]

APPS.JA_JAINCTRB_XMLP_PKG dependencies on HR_ORGANIZATION_UNITS

Line 47: HR_ORGANIZATION_UNITS

43: SELECT
44: NAME
45: INTO V_NAME
46: FROM
47: HR_ORGANIZATION_UNITS
48: WHERE NVL(ORGANIZATION_ID
49: ,0) = NVL(ORG_ID
50: ,0);
51: RETURN (V_NAME);

Line 441: HR_ORGANIZATION_UNITS

437: CURSOR FOR_LOCATION IS
438: SELECT
439: LOCATION_ID
440: FROM
441: HR_ORGANIZATION_UNITS
442: WHERE ORGANIZATION_ID = NVL(ORG_ID
443: ,0);
444: CURSOR FOR_ADDRESS IS
445: SELECT