DBA Data[Home] [Help]

APPS.ARW_SEARCH_CUSTOMERS dependencies on AR_CUSTOMERS_ASSIGNED_V

Line 854: select cust_account_id from ar_customers_assigned_v where party_id=p_party_id AND cust_account_id=nvl(p_customer_id,cust_account_id)

850:
851: /* Check for account level access and insert all bill to sites */
852:
853: FOR customer_assigned_record IN (
854: select cust_account_id from ar_customers_assigned_v where party_id=p_party_id AND cust_account_id=nvl(p_customer_id,cust_account_id)
855: )LOOP
856:
857: FOR account_assigned_site IN (
858: select CUST_ACCT_SITE_ID from hz_cust_acct_sites where CUST_ACCOUNT_ID=customer_assigned_record.cust_account_id

Line 981: select cust_account_id from ar_customers_assigned_v where cust_account_id=nvl(p_customer_id,cust_account_id)

977:
978: /* Check for account level access and insert all bill to sites */
979:
980: FOR customer_assigned_record IN (
981: select cust_account_id from ar_customers_assigned_v where cust_account_id=nvl(p_customer_id,cust_account_id)
982: )LOOP
983:
984: FOR account_assigned_site IN (
985: select CUST_ACCT_SITE_ID from hz_cust_acct_sites where CUST_ACCOUNT_ID=customer_assigned_record.cust_account_id