APPS.RLM_RLMDMSIQ_XMLP_PKG dependencies on HZ_PARTIES

Line 23: HZ_PARTIES PARTY,

19: CURSOR CUR_CUST_NAME(V_CUSTOMER_ID IN NUMBER) IS
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

Line 105: HZ_PARTIES PARTY

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);
109: EXCEPTION