DBA Data[Home] [Help]

APPS.RLM_RLMDMCOM_XMLP_PKG dependencies on HZ_CUST_ACCOUNTS

Line 330: V_ACCOUNT_NUM HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE;

326: RETURN (NULL);
327: END CF_ORDERNUMFORMULA;
328:
329: FUNCTION CF_CUSTOMER_NUMBER_MEANFORMULA(CUSTOMER_NUMBER IN NUMBER) RETURN CHAR IS
330: V_ACCOUNT_NUM HZ_CUST_ACCOUNTS.ACCOUNT_NUMBER%TYPE;
331: CURSOR CUR_CUSTOMER_NUMBER(CUST_NUM IN NUMBER) IS
332: SELECT
333: CUST_ACCT.ACCOUNT_NUMBER
334: FROM

Line 336: HZ_CUST_ACCOUNTS CUST_ACCT

332: SELECT
333: CUST_ACCT.ACCOUNT_NUMBER
334: FROM
335: HZ_PARTIES PARTY,
336: HZ_CUST_ACCOUNTS CUST_ACCT
337: WHERE PARTY.PARTY_ID = CUST_ACCT.PARTY_ID
338: AND CUST_ACCT.CUST_ACCOUNT_ID = CUST_NUM;
339: BEGIN
340: OPEN CUR_CUSTOMER_NUMBER(CUSTOMER_NUMBER);