APPS.RLM_RLMDMSIQ_XMLP_PKG dependencies on HZ_CUST_ACCOUNTS

Line 24: HZ_CUST_ACCOUNTS CUST_ACCT

20: SELECT
21: PARTY.PARTY_NAME
22: FROM
23: HZ_PARTIES PARTY,
24: HZ_CUST_ACCOUNTS CUST_ACCT
25: WHERE PARTY.PARTY_ID = CUST_ACCT.PARTY_ID
26: AND CUST_ACCT.CUST_ACCOUNT_ID = V_CUSTOMER_ID;
27: CURSOR CUR_SHIP_FROM(V_SHIP_FROM IN NUMBER) IS
28: SELECT

Line 87: HZ_CUST_ACCOUNTS CUST_ACCT

83: SELECT
84: CUST_ACCT.ACCOUNT_NUMBER
85: INTO V_CUST_NUMBER
86: FROM
87: HZ_CUST_ACCOUNTS CUST_ACCT
88: WHERE CUST_ACCT.CUST_ACCOUNT_ID = SOLD_TO_ORG_ID;
89: RETURN (V_CUST_NUMBER);
90: EXCEPTION
91: WHEN OTHERS THEN

Line 104: HZ_CUST_ACCOUNTS CUST_ACCT,

100: ,1
101: ,50) CUSTOMER_NAME
102: INTO V_CUST_NAME
103: FROM
104: HZ_CUST_ACCOUNTS CUST_ACCT,
105: HZ_PARTIES PARTY
106: WHERE CUST_ACCT.CUST_ACCOUNT_ID = SOLD_TO_ORG_ID
107: AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID;
108: RETURN (V_CUST_NAME);