APPS.ARH_ADDR_PKG dependencies on HZ_CUST_ACCT_SITES_ALL

Line 2059: (select org_id from hz_cust_acct_sites_all where cust_acct_site_id = p_address_id);

2055: select change_printed_invoice_flag
2056: into check_value
2057: from ar_system_parameters_all
2058: where org_id =
2059: (select org_id from hz_cust_acct_sites_all where cust_acct_site_id = p_address_id);
2060:
2061: --Bug fix 2183072 Handled the exception.
2062: EXCEPTION
2063: WHEN NO_DATA_FOUND THEN

Line 2213: (select org_id from hz_cust_acct_sites_all where cust_acct_site_id = p_address_id);

2209: select change_printed_invoice_flag
2210: into check_value
2211: from ar_system_parameters_all
2212: where org_id =
2213: (select org_id from hz_cust_acct_sites_all where cust_acct_site_id = p_address_id);
2214:
2215: --Bug fix 2183072 Handled the exception.
2216: EXCEPTION
2217: WHEN NO_DATA_FOUND THEN

Line 2370: hz_cust_acct_sites_all acct_site

2366: SELECT acct_site.cust_account_id,
2367: acct_site.cust_acct_site_id
2368: FROM hz_locations loc,
2369: hz_party_sites party_site,
2370: hz_cust_acct_sites_all acct_site
2371: WHERE loc.location_id = party_site.location_id
2372: AND party_site.party_site_id = acct_site.party_site_id
2373: AND loc.location_id = p_location_id;
2374: --

Line 2388: hz_cust_acct_sites_all acct_site

2384: CURSOR c_org_for_loc IS
2385: select distinct acct_site.org_id
2386: from hz_locations loc,
2387: hz_party_sites party_site,
2388: hz_cust_acct_sites_all acct_site
2389: where loc.location_id = party_site.location_id
2390: and party_site.party_site_id = acct_site.party_site_id
2391: and loc.location_id = p_location_id;
2392:

Line 2555: hz_cust_acct_sites_all acct_site

2551: SELECT acct_site.cust_account_id,
2552: acct_site.cust_acct_site_id
2553: FROM hz_locations loc,
2554: hz_party_sites party_site,
2555: hz_cust_acct_sites_all acct_site
2556: WHERE loc.location_id = party_site.location_id
2557: AND party_site.party_site_id = acct_site.party_site_id
2558: AND loc.location_id = p_location_id;
2559: --

Line 2572: hz_cust_acct_sites_all acct_site

2568: CURSOR c_org_for_loc IS
2569: select distinct acct_site.org_id
2570: from hz_locations loc,
2571: hz_party_sites party_site,
2572: hz_cust_acct_sites_all acct_site
2573: where loc.location_id = party_site.location_id
2574: and party_site.party_site_id = acct_site.party_site_id
2575: and loc.location_id = p_location_id;
2576: --

Line 2741: hz_cust_acct_sites_all acct_site

2737: SELECT acct_site.cust_account_id,
2738: acct_site.cust_acct_site_id
2739: FROM hz_locations loc,
2740: hz_party_sites party_site,
2741: hz_cust_acct_sites_all acct_site
2742: WHERE loc.location_id = party_site.location_id
2743: AND party_site.party_site_id = acct_site.party_site_id
2744: AND loc.location_id = p_location_id;
2745: --

Line 2758: hz_cust_acct_sites_all acct_site

2754: CURSOR c_org_for_loc IS
2755: select distinct acct_site.org_id
2756: from hz_locations loc,
2757: hz_party_sites party_site,
2758: hz_cust_acct_sites_all acct_site
2759: where loc.location_id = party_site.location_id
2760: and party_site.party_site_id = acct_site.party_site_id
2761: and loc.location_id = p_location_id;
2762:

Line 3416: hz_cust_acct_sites_all acct_site

3412: cursor c_cust_addrs is
3413: select acct_site.cust_account_id, acct_site.cust_acct_site_id
3414: from hz_locations loc,
3415: hz_party_sites party_site,
3416: hz_cust_acct_sites_all acct_site
3417: where loc.location_id = party_site.location_id
3418: and party_site.party_site_id = acct_site.party_site_id
3419: and loc.location_id = p_location_id;
3420: /*bug 4605384 cursor for loc*/

Line 3425: hz_cust_acct_sites_all acct_site

3421: cursor c_org_for_loc is
3422: select distinct acct_site.org_id
3423: from hz_locations loc,
3424: hz_party_sites party_site,
3425: hz_cust_acct_sites_all acct_site
3426: where loc.location_id = party_site.location_id
3427: and party_site.party_site_id = acct_site.party_site_id
3428: and loc.location_id = p_location_id;
3429: BEGIN