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);
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;