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 9343: FROM HZ_CUST_ACCOUNTS CUST_ACCT

9339: IF x_header_rec.customer_id is NOT NULL THEN
9340: -- Following query is changed as per TCA obsolescence project.
9341: SELECT ACCOUNT_NUMBER
9342: INTO x_customer_number
9343: FROM HZ_CUST_ACCOUNTS CUST_ACCT
9344: WHERE CUST_ACCT.CUST_ACCOUNT_ID = x_header_rec.Customer_Id;
9345: END IF;
9346: --
9347: IF (l_debug <> -1) THEN

Line 9420: FROM HZ_CUST_ACCOUNTS CUST_ACCT

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