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 344: ,jl_zz_ar_tx_groups tg

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

Line 388: ,jl_zz_ar_tx_groups tg

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

Line 431: ,jl_zz_ar_tx_groups tg

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

Line 471: FROM jl_zz_ar_tx_groups tg

467: UNION
468: SELECT tg.tax_code tax_code,
469: NULL,
470: p_ship_from_warehouse_id
471: FROM jl_zz_ar_tx_groups tg
472: WHERE tg.tax_category_id = p_tax_category_id
473: AND tg.contributor_type = p_contributor_type
474: AND tg.transaction_nature = p_transaction_nature
475: AND tg.establishment_type = p_establishment_type

Line 513: FROM jl_zz_ar_tx_groups tg

509: UNION
510: SELECT tg.tax_code,
511: NULL,
512: NULL
513: FROM jl_zz_ar_tx_groups tg
514: WHERE tg.tax_category_id = p_tax_category_id
515: AND tg.contributor_type = p_contributor_type
516: AND tg.transaction_nature = p_transaction_nature
517: AND tg.establishment_type = p_establishment_type

Line 560: ,jl_zz_ar_tx_groups tg

556: NULL,
557: ml.memo_line_id
558: FROM ar_memo_lines ml
559: ,ar_vat_tax vt
560: ,jl_zz_ar_tx_groups tg
561: ,ar_vat_tax vt1
562: WHERE memo_line_id = p_memo_line_id
563: AND ml.tax_code = vt.tax_code
564: AND vt.tax_type = 'TAX_GROUP'

Line 697: FROM jl_zz_ar_tx_groups gt

693: CURSOR c_exc_tax_group IS
694: SELECT gt.tax_code,
695: gt.base_rate,
696: gt.tax_group_record_id
697: FROM jl_zz_ar_tx_groups gt
698: WHERE gt.group_tax_id = p_group_tax_id
699: AND gt.tax_category_id = p_tax_category_id
700: AND gt.contributor_type = p_contributor_type
701: AND gt.transaction_nature = p_transaction_nature

Line 1799: FROM jl_zz_ar_tx_groups tg

1795: l_dummy := 0;
1796: BEGIN
1797: SELECT 1
1798: INTO l_dummy
1799: FROM jl_zz_ar_tx_groups tg
1800: WHERE tg.group_tax_id = p_tax_group
1801: AND tg.tax_category_id = p_tax_category_id
1802: AND tg.transaction_nature = l_curr_nature_class_value
1803: AND tg.establishment_type = l_establishment_type

Line 2057: FROM jl_zz_ar_tx_groups

2053: INTO p_min_tax_rate,
2054: p_min_tax_amount,
2055: p_min_taxable_basis,
2056: l_use_tx_categ_thresholds
2057: FROM jl_zz_ar_tx_groups
2058: WHERE group_tax_id = p_tax_group_id
2059: AND tax_category_id = p_tax_category_id
2060: AND establishment_type = p_establishment_type
2061: AND contributor_type = p_contributor_type

Line 3407: FROM jl_zz_ar_tx_groups tg,

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