APPS.RLM_VALIDATEDEMAND_SV dependencies on HZ_CUST_ACCOUNTS

Line 5328: FROM HZ_CUST_ACCOUNTS CUST_ACCT

5324: --
5325: -- Following query is changed as per TCA obsolescence project.
5326: SELECT CUST_ACCT.PRICE_LIST_ID
5327: INTO x_lines_rec.PRICE_LIST_ID
5328: FROM HZ_CUST_ACCOUNTS CUST_ACCT
5329: WHERE CUST_ACCT.CUST_ACCOUNT_ID = x_header_rec.customer_id;
5330: EXCEPTION
5331: WHEN NO_DATA_FOUND THEN
5332: --

Line 9419: FROM HZ_CUST_ACCOUNTS CUST_ACCT

9415: IF x_header_rec.customer_id is NOT NULL THEN
9416: -- Following query is changed as per TCA obsolescence project.
9417: SELECT ACCOUNT_NUMBER
9418: INTO x_customer_number
9419: FROM HZ_CUST_ACCOUNTS CUST_ACCT
9420: WHERE CUST_ACCT.CUST_ACCOUNT_ID = x_header_rec.Customer_Id;
9421: END IF;
9422: --
9423: IF (l_debug <> -1) THEN

Line 9496: FROM HZ_CUST_ACCOUNTS CUST_ACCT

9492: IF x_header_rec.customer_id is NOT NULL THEN
9493: -- Following query is changed as per TCA obsolescence project.
9494: SELECT ACCOUNT_NUMBER
9495: INTO x_customer_number
9496: FROM HZ_CUST_ACCOUNTS CUST_ACCT
9497: WHERE CUST_ACCT.CUST_ACCOUNT_ID = x_header_rec.Customer_Id;
9498: END IF;
9499: --
9500: IF (l_debug <> -1) THEN