APPS.RLM_RLMDMCOM_XMLP_PKG dependencies on HZ_CUST_ACCT_SITES

Line 30: HZ_CUST_ACCT_SITES

26: CURSOR CUR_P_SHIP_TO(NU_SHIP_TO IN NUMBER) IS
27: SELECT
28: ECE_TP_LOCATION_CODE
29: FROM
30: HZ_CUST_ACCT_SITES
31: WHERE CUST_ACCT_SITE_ID = NU_SHIP_TO;
32: CURSOR CUR_DEMAND_TYPE(V_DEMAND_TYPE IN VARCHAR2) IS
33: SELECT
34: MEANING

Line 163: V_SHIP_TO HZ_CUST_ACCT_SITES.ECE_TP_LOCATION_CODE%TYPE;

159: RETURN (NULL);
160: END CF_SHIP_FROM_ORG_IDFORMULA;
161:
162: FUNCTION CF_SHIP_TOFORMULA(SHIP_TO_ADDRESS_ID IN NUMBER) RETURN CHAR IS
163: V_SHIP_TO HZ_CUST_ACCT_SITES.ECE_TP_LOCATION_CODE%TYPE;
164: CURSOR CUR_SHIP_TO(NU_SHIP_TO IN NUMBER) IS
165: SELECT
166: ECE_TP_LOCATION_CODE
167: FROM

Line 168: HZ_CUST_ACCT_SITES

164: CURSOR CUR_SHIP_TO(NU_SHIP_TO IN NUMBER) IS
165: SELECT
166: ECE_TP_LOCATION_CODE
167: FROM
168: HZ_CUST_ACCT_SITES
169: WHERE CUST_ACCT_SITE_ID = NU_SHIP_TO;
170: BEGIN
171: OPEN CUR_SHIP_TO(SHIP_TO_ADDRESS_ID);
172: FETCH CUR_SHIP_TO