APPS.ARH_ADDR_PKG dependencies on AR_SYSTEM_PARAMETERS

Line 2057: from ar_system_parameters_all

2053:
2054: BEGIN
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.

Line 2211: from ar_system_parameters_all

2207: BEGIN
2208: arp_debug.debug('transaction_morg_exists.p_address_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.

Line 2381: FROM ar_system_parameters;

2377: /*Bug 4605384*/
2378: /*
2379: CURSOR c_check IS
2380: SELECT change_printed_invoice_flag
2381: FROM ar_system_parameters;
2382: */
2383: --
2384: CURSOR c_org_for_loc IS
2385: select distinct acct_site.org_id

Line 2415: from ar_system_parameters_all where org_id=l_org_id;

2411: exit when c_org_for_loc%NOTFOUND;
2412: BEGIN
2413: select change_printed_invoice_flag
2414: into check_value
2415: from ar_system_parameters_all where org_id=l_org_id;
2416:
2417: EXCEPTION
2418: WHEN NO_DATA_FOUND THEN
2419: close c_org_for_loc;

Line 2566: FROM ar_system_parameters;

2562: /*Bug 4605384*/
2563: /*
2564: CURSOR c_check IS
2565: SELECT change_printed_invoice_flag
2566: FROM ar_system_parameters;
2567: */
2568: CURSOR c_org_for_loc IS
2569: select distinct acct_site.org_id
2570: from hz_locations loc,

Line 2605: from ar_system_parameters_all where org_id=l_org_id;

2601: exit when c_org_for_loc%NOTFOUND;
2602: BEGIN
2603: select change_printed_invoice_flag
2604: into check_value
2605: from ar_system_parameters_all where org_id=l_org_id;
2606:
2607: EXCEPTION
2608: WHEN NO_DATA_FOUND THEN
2609: close c_org_for_loc;

Line 2752: FROM ar_system_parameters;

2748: /*Bug 4605384 Changed as per consistency for changes allowed in address*/
2749: /*
2750: CURSOR c_check IS
2751: SELECT change_printed_invoice_flag
2752: FROM ar_system_parameters;
2753: */
2754: CURSOR c_org_for_loc IS
2755: select distinct acct_site.org_id
2756: from hz_locations loc,

Line 2792: from ar_system_parameters_all where org_id=l_org_id;

2788: exit when c_org_for_loc%NOTFOUND;
2789: BEGIN
2790: select change_printed_invoice_flag
2791: into check_value
2792: from ar_system_parameters_all where org_id=l_org_id;
2793:
2794: EXCEPTION
2795: WHEN NO_DATA_FOUND THEN
2796: close c_org_for_loc;

Line 3455: from ar_system_parameters_all where org_id=l_org_id;

3451: exit when c_org_for_loc%NOTFOUND;
3452: BEGIN
3453: select change_printed_invoice_flag
3454: into check_value
3455: from ar_system_parameters_all where org_id=l_org_id;
3456:
3457: --Bug fix 2183072 Handled the exception.
3458: EXCEPTION
3459: WHEN NO_DATA_FOUND THEN