APPS.JL_ZZ_TAX dependencies on JL_ZZ_AR_TX_GROUPS

Line 297: ,jl_zz_ar_tx_groups tg

293: NULL,
294: si.inventory_item_id
295: FROM mtl_system_items si
296: ,ar_vat_tax vt
297: ,jl_zz_ar_tx_groups tg
298: ,ar_vat_tax vt1
299: WHERE si.inventory_item_id = p_inventory_item_id
300: AND si.organization_id = p_inventory_organization_id
301: AND si.tax_code = vt.tax_code

Line 345: ,jl_zz_ar_tx_groups tg

341: NULL,
342: c.cust_account_id
343: FROM hz_cust_accounts c
344: ,ar_vat_tax vt
345: ,jl_zz_ar_tx_groups tg
346: ,ar_vat_tax vt1
347: WHERE c.cust_account_id = NVL(p_ship_to_customer_id,
348: p_bill_to_customer_id)
349: AND c.tax_code = vt.tax_code

Line 390: ,jl_zz_ar_tx_groups tg

386: NULL,
387: su.site_use_id
388: FROM hz_cust_site_uses su
389: ,ar_vat_tax vt
390: ,jl_zz_ar_tx_groups tg
391: ,ar_vat_tax vt1
392: WHERE su.site_use_id = p_bill_to_site_use_id
393: AND su.tax_code = vt.tax_code
394: AND vt.tax_type = 'TAX_GROUP'

Line 434: ,jl_zz_ar_tx_groups tg

430: NULL,
431: su.site_use_id
432: FROM hz_cust_site_uses su
433: ,ar_vat_tax vt
434: ,jl_zz_ar_tx_groups tg
435: ,ar_vat_tax vt1
436: WHERE su.site_use_id = p_ship_to_site_use_id
437: AND su.tax_code = vt.tax_code
438: AND vt.tax_type = 'TAX_GROUP'

Line 475: FROM jl_zz_ar_tx_groups tg

471: UNION
472: SELECT tg.tax_code tax_code,
473: NULL,
474: p_ship_from_warehouse_id
475: FROM jl_zz_ar_tx_groups tg
476: WHERE tg.tax_category_id = p_tax_category_id
477: AND tg.contributor_type = p_contributor_type
478: AND tg.transaction_nature = p_transaction_nature
479: AND tg.establishment_type = p_establishment_type

Line 518: FROM jl_zz_ar_tx_groups tg

514: UNION
515: SELECT tg.tax_code,
516: NULL,
517: NULL
518: FROM jl_zz_ar_tx_groups tg
519: WHERE tg.tax_category_id = p_tax_category_id
520: AND tg.contributor_type = p_contributor_type
521: AND tg.transaction_nature = p_transaction_nature
522: AND tg.establishment_type = p_establishment_type

Line 567: ,jl_zz_ar_tx_groups tg

563: NULL,
564: ml.memo_line_id
565: FROM ar_memo_lines ml
566: ,ar_vat_tax vt
567: ,jl_zz_ar_tx_groups tg
568: ,ar_vat_tax vt1
569: WHERE memo_line_id = p_memo_line_id
570: AND ml.tax_code = vt.tax_code
571: AND vt.tax_type = 'TAX_GROUP'

Line 713: FROM jl_zz_ar_tx_groups gt

709: CURSOR c_exc_tax_group IS
710: SELECT gt.tax_code,
711: gt.base_rate,
712: gt.tax_group_record_id
713: FROM jl_zz_ar_tx_groups gt
714: WHERE gt.group_tax_id = p_group_tax_id
715: AND gt.tax_category_id = p_tax_category_id
716: AND gt.contributor_type = p_contributor_type
717: AND gt.transaction_nature = p_transaction_nature

Line 1819: FROM jl_zz_ar_tx_groups tg

1815: l_dummy := 0;
1816: BEGIN
1817: SELECT 1
1818: INTO l_dummy
1819: FROM jl_zz_ar_tx_groups tg
1820: WHERE tg.group_tax_id = p_tax_group
1821: AND tg.tax_category_id = p_tax_category_id
1822: AND tg.transaction_nature = l_curr_nature_class_value
1823: AND tg.establishment_type = l_establishment_type

Line 2077: FROM jl_zz_ar_tx_groups

2073: INTO p_min_tax_rate,
2074: p_min_tax_amount,
2075: p_min_taxable_basis,
2076: l_use_tx_categ_thresholds
2077: FROM jl_zz_ar_tx_groups
2078: WHERE group_tax_id = p_tax_group_id
2079: AND tax_category_id = p_tax_category_id
2080: AND establishment_type = p_establishment_type
2081: AND contributor_type = p_contributor_type

Line 3485: FROM jl_zz_ar_tx_groups tg,

3481: v_tax_category_to_reduce_id,
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