DBA Data[Home] [Help]

APPS.JL_ZZ_TAX dependencies on AR_SYSTEM_PARAMETERS_ALL

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.