DBA Data[Home] [Help]

APPS.JL_ZZ_TAX dependencies on AR_SYSTEM_PARAMETERS_ALL

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.