APPS.PA_BILL_WORKBENCH_INVOICE dependencies on HZ_CUST_ACCOUNTS

Line 451: FROM HZ_CUST_ACCOUNTS

447: AND customer_prospect_code = 'CUSTOMER'; */
448:
449: Cursor Cust_Cur is
450: SELECT 1
451: FROM HZ_CUST_ACCOUNTS
452: WHERE cust_account_id = l_customer_id
453: AND NVL(status, 'A') <> 'A';
454:
455: BEGIN

Line 606: SELECT count(*) INTO l_inactive_customer FROM hz_cust_accounts

602: WHERE customer_id = inv_rec.customer_id
603: AND NVL(status,'A') <> 'A'
604: AND customer_prospect_code = 'CUSTOMER'; */
605:
606: SELECT count(*) INTO l_inactive_customer FROM hz_cust_accounts
607: WHERE cust_account_id = inv_rec.customer_id
608: AND NVL(status,'A') <> 'A';
609:
610: IF l_inactive_customer >0 THEN