APPS.RLM_RLMDMCOM_XMLP_PKG dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 24: ORG_ORGANIZATION_DEFINITIONS

20: CURSOR CUR_SHIP_FROM(V_SHIP_FROM IN NUMBER) IS
21: SELECT
22: ORGANIZATION_CODE
23: FROM
24: ORG_ORGANIZATION_DEFINITIONS
25: WHERE ORGANIZATION_ID = V_SHIP_FROM;
26: CURSOR CUR_P_SHIP_TO(NU_SHIP_TO IN NUMBER) IS
27: SELECT
28: ECE_TP_LOCATION_CODE

Line 144: V_SHIP_FROM ORG_ORGANIZATION_DEFINITIONS.ORGANIZATION_NAME%TYPE;

140: RETURN (NULL);
141: END BEFOREREPORT;
142:
143: FUNCTION CF_SHIP_FROM_ORG_IDFORMULA(SHIP_FROM_ORG_ID IN NUMBER) RETURN CHAR IS
144: V_SHIP_FROM ORG_ORGANIZATION_DEFINITIONS.ORGANIZATION_NAME%TYPE;
145: CURSOR CUR_SHIP_FROM(NU_SHIP_FROM IN NUMBER) IS
146: SELECT
147: ORGANIZATION_NAME
148: FROM

Line 149: ORG_ORGANIZATION_DEFINITIONS HRORGS

145: CURSOR CUR_SHIP_FROM(NU_SHIP_FROM IN NUMBER) IS
146: SELECT
147: ORGANIZATION_NAME
148: FROM
149: ORG_ORGANIZATION_DEFINITIONS HRORGS
150: WHERE HRORGS.ORGANIZATION_ID = NU_SHIP_FROM;
151: BEGIN
152: OPEN CUR_SHIP_FROM(SHIP_FROM_ORG_ID);
153: FETCH CUR_SHIP_FROM