APPS.XDP_ORDER dependencies on HZ_CUST_ACCOUNTS_ALL

Line 929: FROM HZ_CUST_ACCOUNTS_ALL CUST

925: --===================================
926: IF p_order_header.cust_account_id IS NOT NULL THEN
927: BEGIN
928: SELECT '1' INTO lv_cust_present
929: FROM HZ_CUST_ACCOUNTS_ALL CUST
930: WHERE CUST.CUST_ACCOUNT_ID = p_order_header.cust_account_id;
931: EXCEPTION
932: WHEN NO_DATA_FOUND THEN
933: RAISE e_cust_acc_id_invalid;

Line 944: FROM HZ_CUST_ACCOUNTS_ALL CUST

940: ELSIF p_order_header.CUST_ACCOUNT_ID IS NULL
941: AND p_order_header.account_number IS NOT NULL THEN
942: BEGIN
943: SELECT CUST.CUST_ACCOUNT_ID INTO p_order_header.cust_account_id
944: FROM HZ_CUST_ACCOUNTS_ALL CUST
945: WHERE CUST.ACCOUNT_NUMBER = p_order_header.account_number;
946: EXCEPTION
947: WHEN NO_DATA_FOUND THEN
948: RAISE e_cust_acc_num_invalid;