APPS.RLM_RLMDMSIQ_XMLP_PKG dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 31: ORG_ORGANIZATION_DEFINITIONS

27: CURSOR CUR_SHIP_FROM(V_SHIP_FROM IN NUMBER) IS
28: SELECT
29: ORGANIZATION_CODE
30: FROM
31: ORG_ORGANIZATION_DEFINITIONS
32: WHERE ORGANIZATION_ID = V_SHIP_FROM;
33: BEGIN
34: L_SHIP_TO := 'SHIP_TO';
35: L_STATUS := 'A';

Line 121: ORG_ORGANIZATION_DEFINITIONS HRORGS

117: SELECT
118: ORGANIZATION_CODE
119: INTO V_SHIP_FROM
120: FROM
121: ORG_ORGANIZATION_DEFINITIONS HRORGS
122: WHERE SHIP_FROM_ORG_ID = HRORGS.ORGANIZATION_ID;
123: RETURN (V_SHIP_FROM);
124: EXCEPTION
125: WHEN OTHERS THEN

Line 130: V_SHIP_FROM ORG_ORGANIZATION_DEFINITIONS.ORGANIZATION_NAME%TYPE;

126: RETURN (NULL);
127: END SHIP_FROM_CODEFORMULA;
128:
129: FUNCTION SHIP_FROM_NAMEFORMULA(SHIP_FROM_ORG_ID IN NUMBER) RETURN CHAR IS
130: V_SHIP_FROM ORG_ORGANIZATION_DEFINITIONS.ORGANIZATION_NAME%TYPE;
131: BEGIN
132: SELECT
133: ORGANIZATION_NAME
134: INTO V_SHIP_FROM

Line 136: ORG_ORGANIZATION_DEFINITIONS HRORGS

132: SELECT
133: ORGANIZATION_NAME
134: INTO V_SHIP_FROM
135: FROM
136: ORG_ORGANIZATION_DEFINITIONS HRORGS
137: WHERE SHIP_FROM_ORG_ID = HRORGS.ORGANIZATION_ID;
138: RETURN (V_SHIP_FROM);
139: EXCEPTION
140: WHEN OTHERS THEN