APPS.ARI_UTILITIES dependencies on AR_SITES_ASSIGNED_V

Line 28: FROM ar_sites_assigned_v a,HZ_CUST_SITE_USES b

24: FROM ar_customers_assigned_v
25: WHERE party_id = p_person_party_id);
26: CURSOR customer_site_assigned_cur(p_person_party_id IN VARCHAR2, p_customer_site_use_id IN VARCHAR2) IS
27: SELECT 'Y'
28: FROM ar_sites_assigned_v a,HZ_CUST_SITE_USES b
29: where a.cust_acct_site_id = b.cust_acct_site_id
30: and b.SITE_USE_CODE = 'BILL_TO'
31: AND party_id = p_person_party_id and site_use_id = p_customer_site_use_id;
32:

Line 728: FROM ar_sites_assigned_v a,HZ_CUST_SITE_USES b

724: SELECT 'Y'
725: INTO user_access
726: FROM dual
727: WHERE EXISTS (SELECT 'Y'
728: FROM ar_sites_assigned_v a,HZ_CUST_SITE_USES b
729: WHERE a.cust_acct_site_id = b.cust_acct_site_id
730: AND b.SITE_USE_CODE = 'BILL_TO'
731: AND party_id = p_person_party_id
732: AND site_use_id = p_customer_site_use_id );

Line 1650: select count(*) into l_site_access_count from ar_sites_assigned_v acct_sites_count

1646: IF l_account_access_count > 0 THEN
1647: RETURN 0;
1648: END IF;
1649:
1650: select count(*) into l_site_access_count from ar_sites_assigned_v acct_sites_count
1651: where acct_sites_count.party_id=p_party_id
1652: and acct_sites_count.cust_account_id=p_customer_id
1653: and INSTR(ARI_UTILITIES.GET_SITE_USE_CODE(acct_sites_count.CUST_ACCT_SITE_ID), 'BILL_TO')>0;
1654:

Line 1659: select ARI_UTILITIES.get_bill_to_site_use_id(CUST_ACCT_SITE_ID) from ar_sites_assigned_v where

1655: select count(*) into l_flag from(
1656: select trx_number,CUSTOMER_SITE_USE_ID from ar_payment_schedules where trx_number=p_trx_number
1657: and CUSTOMER_SITE_USE_ID in
1658: (
1659: select ARI_UTILITIES.get_bill_to_site_use_id(CUST_ACCT_SITE_ID) from ar_sites_assigned_v where
1660: party_id=p_party_id
1661: and cust_account_id=p_customer_id
1662: )
1663: );