APPS.JL_ZZ_TAX dependencies on AR_SYSTEM_PARAMETERS

Line 618: ,ar_system_parameters sp

614: ,hz_cust_acct_sites ad
615: ,hz_cust_site_uses su
616: ,hz_party_sites p
617: ,hz_locations lc
618: ,ar_system_parameters sp
619: ,hr_locations_all hrl
620: WHERE hrl.location_id = p_warehouse_location_id
621: AND loc.ship_from_code = hrl.REGION_2
622: AND loc.ship_to_segment_id = lv.geography_id

Line 649: ,ar_system_parameters sp

645: ,hz_cust_acct_sites ad
646: ,hz_cust_site_uses su
647: ,hz_party_sites p
648: ,hz_locations loc
649: ,ar_system_parameters sp
650: ,hr_locations_all hrl
651: WHERE hrl.location_id = p_warehouse_location_id
652: AND exc.ship_from_code = hrl.REGION_2
653: AND exc.ship_to_segment_id = lv.geography_id

Line 680: ,ar_system_parameters sp

676: ,hz_cust_acct_sites ad
677: ,hz_cust_site_uses su
678: ,hz_party_sites p
679: ,hz_locations loc
680: ,ar_system_parameters sp
681: ,hr_locations_all hrl
682: WHERE hrl.location_id = p_warehouse_location_id
683: AND exi.ship_from_code = hrl.REGION_2
684: AND exi.ship_to_segment_id = lv.geography_id

Line 943: ar_system_parameters sp

939: CURSOR c_rule_default IS
940: SELECT tr.rule rule,
941: tr.rule_id rule_id
942: FROM jl_zz_ar_tx_rules tr,
943: ar_system_parameters sp
944: WHERE tr.tax_rule_level = p_level
945: AND tr.tax_category_id = p_tax_category_id
946: AND tr.contributor_type = 'DEFAULT'
947: AND tr.cust_trx_type_id =

Line 1169: ar_system_parameters sp

1165: CURSOR c_rule_default IS
1166: SELECT tr.rule rule,
1167: tr.rule_id rule_id
1168: FROM jl_zz_ar_tx_rules tr,
1169: ar_system_parameters sp
1170: WHERE tr.tax_rule_level = p_level
1171: AND tr.tax_category_id = p_tax_category_id
1172: AND tr.contributor_type = 'DEFAULT'
1173: AND tr.cust_trx_type_id =

Line 1410: ar_system_parameters sp

1406: CURSOR c_rule_default IS
1407: SELECT tr.rule rule,
1408: tr.rule_id rule_id
1409: FROM jl_zz_ar_tx_rules tr,
1410: ar_system_parameters sp
1411: WHERE tr.tax_rule_level = p_level
1412: AND tr.tax_category_id = p_tax_category_id
1413: AND tr.contributor_type = 'DEFAULT'
1414: AND tr.cust_trx_type_id =

Line 2547: l_jlzz_ar_tx_use_whole_operatn ar_system_parameters_all.global_attribute19%type;

2543: AND tc1.threshold_check_grp_by = 'DOCUMENT';
2544:
2545:
2546:
2547: l_jlzz_ar_tx_use_whole_operatn ar_system_parameters_all.global_attribute19%type;
2548:
2549: BEGIN
2550: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2551:

Line 3384: ar_system_parameters_all sp

3380: v_location_structure_id,
3381: v_location_segment_num,
3382: v_set_of_books_id
3383: FROM jl_zz_ar_tx_categ tc,
3384: ar_system_parameters_all sp
3385: WHERE tc.tax_category_id = p_tax_category_id
3386: AND p_trx_date <= tc.end_date_active
3387: AND p_trx_date >= NVL(tc.start_date_active, p_trx_date)
3388: AND nvl(tc.org_id,-99) = nvl(sp.org_id,-99)

Line 3408: ar_system_parameters_all sp

3404: v_location_structure_id,
3405: v_location_segment_num,
3406: v_set_of_books_id
3407: FROM jl_zz_ar_tx_groups tg,
3408: ar_system_parameters_all sp
3409: WHERE tg.tax_category_id = p_tax_category_id
3410: AND tg.group_tax_id = p_group_tax_id
3411: AND tg.contributor_type = p_contributor_type
3412: AND tg.transaction_nature = p_transaction_nature

Line 4017: ar_system_parameters_all sp

4013: v_use_legal_message,
4014: v_legal_message_exception,
4015: l_exchange_rate
4016: FROM ar_vat_tax vt,
4017: ar_system_parameters_all sp
4018: WHERE vt.vat_tax_id = ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.vat_tax_id
4019: AND nvl(vt.org_id,-99) = nvl(sp.org_id,-99);
4020:
4021: --BugFix 2180174 commented the Following IF condition.