DBA Data[Home] [Help]

APPS.JL_ZZ_TAX dependencies on AR_SYSTEM_PARAMETERS

Line 635: ,ar_system_parameters sp

631: ,hz_cust_acct_sites ad
632: ,hz_party_sites p
633: ,hz_locations lc
634: ,hz_geographies lv
635: ,ar_system_parameters sp
636: WHERE su.site_use_id = cp_site_use_id
637: AND ad.cust_acct_site_id = su.cust_acct_site_id
638: AND p.party_site_id = ad.party_site_id
639: AND lc.location_id = p.location_id

Line 664: ,ar_system_parameters sp

660: ,hz_cust_acct_sites ad
661: ,hz_cust_site_uses su
662: ,hz_party_sites p
663: ,hz_locations loc
664: ,ar_system_parameters sp
665: ,hr_locations_all hrl
666: WHERE hrl.location_id = p_warehouse_location_id
667: AND exc.ship_from_code = hrl.REGION_2
668: AND exc.ship_to_segment_id = lv.geography_id

Line 695: ,ar_system_parameters sp

691: ,hz_cust_acct_sites ad
692: ,hz_cust_site_uses su
693: ,hz_party_sites p
694: ,hz_locations loc
695: ,ar_system_parameters sp
696: ,hr_locations_all hrl
697: WHERE hrl.location_id = p_warehouse_location_id
698: AND exi.ship_from_code = hrl.REGION_2
699: AND exi.ship_to_segment_id = lv.geography_id

Line 963: ar_system_parameters sp

959: CURSOR c_rule_default IS
960: SELECT tr.rule rule,
961: tr.rule_id rule_id
962: FROM jl_zz_ar_tx_rules tr,
963: ar_system_parameters sp
964: WHERE tr.tax_rule_level = p_level
965: AND tr.tax_category_id = p_tax_category_id
966: AND tr.contributor_type = 'DEFAULT'
967: AND tr.cust_trx_type_id =

Line 1189: ar_system_parameters sp

1185: CURSOR c_rule_default IS
1186: SELECT tr.rule rule,
1187: tr.rule_id rule_id
1188: FROM jl_zz_ar_tx_rules tr,
1189: ar_system_parameters sp
1190: WHERE tr.tax_rule_level = p_level
1191: AND tr.tax_category_id = p_tax_category_id
1192: AND tr.contributor_type = 'DEFAULT'
1193: AND tr.cust_trx_type_id =

Line 1430: ar_system_parameters sp

1426: CURSOR c_rule_default IS
1427: SELECT tr.rule rule,
1428: tr.rule_id rule_id
1429: FROM jl_zz_ar_tx_rules tr,
1430: ar_system_parameters sp
1431: WHERE tr.tax_rule_level = p_level
1432: AND tr.tax_category_id = p_tax_category_id
1433: AND tr.contributor_type = 'DEFAULT'
1434: AND tr.cust_trx_type_id =

Line 2567: l_jlzz_ar_tx_use_whole_operatn ar_system_parameters_all.global_attribute19%type;

2563: AND tc1.threshold_check_grp_by = 'DOCUMENT';
2564:
2565:
2566:
2567: l_jlzz_ar_tx_use_whole_operatn ar_system_parameters_all.global_attribute19%type;
2568:
2569: BEGIN
2570: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2571:

Line 3462: ar_system_parameters_all sp

3458: v_location_structure_id,
3459: v_location_segment_num,
3460: v_set_of_books_id
3461: FROM jl_zz_ar_tx_categ tc,
3462: ar_system_parameters_all sp
3463: WHERE tc.tax_category_id = p_tax_category_id
3464: AND p_trx_date <= tc.end_date_active
3465: AND p_trx_date >= NVL(tc.start_date_active, p_trx_date)
3466: AND nvl(tc.org_id,-99) = nvl(sp.org_id,-99)

Line 3486: ar_system_parameters_all sp

3482: v_location_structure_id,
3483: v_location_segment_num,
3484: v_set_of_books_id
3485: FROM jl_zz_ar_tx_groups tg,
3486: ar_system_parameters_all sp
3487: WHERE tg.tax_category_id = p_tax_category_id
3488: AND tg.group_tax_id = p_group_tax_id
3489: AND tg.contributor_type = p_contributor_type
3490: AND tg.transaction_nature = p_transaction_nature

Line 4105: ar_system_parameters_all sp

4101: v_use_legal_message,
4102: v_legal_message_exception,
4103: l_exchange_rate
4104: FROM ar_vat_tax vt,
4105: ar_system_parameters_all sp
4106: WHERE vt.vat_tax_id = ZX_PRODUCT_INTEGRATION_PKG.tax_info_rec.vat_tax_id
4107: AND nvl(vt.org_id,-99) = nvl(sp.org_id,-99);
4108:
4109: --BugFix 2180174 commented the Following IF condition.