APPS.JA_JAINPROS_XMLP_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 45: HR_ALL_ORGANIZATION_UNITS

41: SELECT
42: NAME,
43: INTERNAL_ADDRESS_LINE
44: FROM
45: HR_ALL_ORGANIZATION_UNITS
46: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID;
47: V_ORGN_NAME HR_ALL_ORGANIZATION_UNITS.NAME%TYPE;
48: BEGIN
49: OPEN C_ORGANIZATION_NAME(P_INV_ORGANIZATION_ID);

Line 47: V_ORGN_NAME HR_ALL_ORGANIZATION_UNITS.NAME%TYPE;

43: INTERNAL_ADDRESS_LINE
44: FROM
45: HR_ALL_ORGANIZATION_UNITS
46: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID;
47: V_ORGN_NAME HR_ALL_ORGANIZATION_UNITS.NAME%TYPE;
48: BEGIN
49: OPEN C_ORGANIZATION_NAME(P_INV_ORGANIZATION_ID);
50: FETCH C_ORGANIZATION_NAME
51: INTO V_ORGN_NAME,CP_INTADRS;