DBA Data[Home] [Help]

APPS.RLM_RLMSCHRL_XMLP_PKG dependencies on HZ_CUST_ACCOUNTS

Line 11: HZ_CUST_ACCOUNTS CUST_ACCT

7: CUST_ACCT.ACCOUNT_NUMBER
8: INTO CNUM
9: FROM
10: HZ_PARTIES PARTY,
11: HZ_CUST_ACCOUNTS CUST_ACCT
12: WHERE PARTY.PARTY_ID = CUST_ACCT.PARTY_ID
13: AND CUST_ACCT.CUST_ACCOUNT_ID = CUSTOMER_ID;
14: RETURN (CNUM);
15: EXCEPTION

Line 285: HZ_CUST_ACCOUNTS CUST_ACCT

281: WHERE PARTY.PARTY_ID = (
282: SELECT
283: CUST_ACCT.PARTY_ID
284: FROM
285: HZ_CUST_ACCOUNTS CUST_ACCT
286: WHERE CUST_ACCT.CUST_ACCOUNT_ID = P_CUSTOMER );
287: CP_CUSTOMER := CNAME;
288: ELSE
289: CP_CUSTOMER := P_CUSTOMER;