DBA Data[Home] [Help]

APPS.CN_ADJ_DISP_PUB dependencies on HZ_CUST_ACCOUNTS

Line 616: FROM HZ_PARTIES PARTY, HZ_CUST_ACCOUNTS CUST_ACCT

612: IF adj.customer_id IS NOT NULL THEN
613: BEGIN
614: SELECT substrb(PARTY.PARTY_NAME,1,50), CUST_ACCT.ACCOUNT_NUMBER
615: INTO l_customer_name, l_customer_number
616: FROM HZ_PARTIES PARTY, HZ_CUST_ACCOUNTS CUST_ACCT
617: WHERE CUST_ACCT.CUST_ACCOUNT_ID = adj.customer_id
618: AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID;
619: x_adj_tbl(x_adj_count).customer_name := l_customer_name;
620: x_adj_tbl(x_adj_count).customer_number := l_customer_number;