eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JL_ZZ_TAX dependencies on JL_ZZ_AR_TX_CATEG

Line 267: FROM jl_zz_ar_tx_categ cat

263: UNION
264: SELECT cat.tax_code,
265: NULL,
266: NULL
267: FROM jl_zz_ar_tx_categ cat
268: WHERE cat.tax_category_id = p_tax_category_id
269: AND p_trx_date <= cat.end_date_active
270: AND p_trx_date >= NVL(cat.start_date_active,p_trx_date);
271:

Line 713: jl_zz_ar_tx_categ tc,

709: tnr.base_rate,
710: tnr.txn_nature_id
711: FROM jl_zz_ar_tx_nat_rat tnr,
712: jl_zz_ar_tx_att_val tcav,
713: jl_zz_ar_tx_categ tc,
714: jl_zz_ar_tx_cat_att tca,
715: jl_zz_ar_tx_att_cls tcac
716: WHERE tcac.tax_attr_class_code = p_transaction_nature_class
717: AND tcac.tax_category_id = p_tax_category_id

Line 1746: jl_zz_ar_tx_categ tc

1742: l_contributor_type
1743: FROM jl_zz_ar_tx_cus_cls cta,
1744: hz_cust_site_uses rsu,
1745: jl_zz_ar_tx_att_cls ota,
1746: jl_zz_ar_tx_categ tc
1747: WHERE tc.tax_category_id = p_tax_category_id
1748: AND tc.threshold_check_grp_by = 'DOCUMENT'
1749: AND ota.tax_attr_class_type = 'ORGANIZATION_CLASS'
1750: AND ota.tax_category_id = tc.tax_category_id

Line 1768: jl_zz_ar_tx_categ tc

1764: into l_establishment_type,
1765: l_contributor_type
1766: FROM jl_zz_ar_tx_att_cls cta,
1767: jl_zz_ar_tx_att_cls ota,
1768: jl_zz_ar_tx_categ tc
1769: WHERE tc.tax_category_id = p_tax_category_id
1770: AND tc.threshold_check_grp_by = 'DOCUMENT'
1771: AND ota.tax_attr_class_type = 'ORGANIZATION_CLASS'
1772: AND ota.tax_category_id = tc.tax_category_id

Line 2085: FROM jl_zz_ar_tx_categ

2081: WHEN NO_DATA_FOUND THEN
2082: BEGIN
2083: SELECT min_percentage
2084: INTO p_min_tax_rate
2085: FROM jl_zz_ar_tx_categ
2086: WHERE tax_category_id = p_tax_category_id
2087: AND p_trx_date BETWEEN NVL(start_date_active,p_trx_date)
2088: AND end_date_active;
2089: EXCEPTION

Line 2108: FROM jl_zz_ar_tx_categ

2104: WHEN NO_DATA_FOUND THEN
2105: BEGIN
2106: SELECT min_amount
2107: INTO p_min_tax_amount
2108: FROM jl_zz_ar_tx_categ
2109: WHERE tax_category_id = p_tax_category_id
2110: AND p_trx_date BETWEEN NVL(start_date_active,p_trx_date)
2111: AND end_date_active;
2112: EXCEPTION

Line 2131: FROM jl_zz_ar_tx_categ

2127: WHEN NO_DATA_FOUND THEN
2128: BEGIN
2129: SELECT min_taxable_basis
2130: INTO p_min_taxable_basis
2131: FROM jl_zz_ar_tx_categ
2132: WHERE tax_category_id = p_tax_category_id
2133: AND p_trx_date BETWEEN NVL(start_date_active,p_trx_date)
2134: AND end_date_active;
2135: EXCEPTION

Line 2228: ,jl_zz_ar_tx_categ tc1

2224: ,ra_customer_trx_lines rl1
2225: ,ra_customer_trx_lines rlt1
2226: ,ar_vat_tax v1
2227: ,jl_zz_ar_tx_att_cls tcl1
2228: ,jl_zz_ar_tx_categ tc1
2229: WHERE r1.customer_trx_id = rl1.customer_trx_id
2230: AND r1.customer_trx_id = p_prev_cust_trx_id
2231: AND rl1.line_type = 'LINE'
2232: AND r1.customer_trx_id = rlt1.customer_trx_id

Line 2261: ,jl_zz_ar_tx_categ tc1

2257: ,ra_customer_trx_lines rl1
2258: ,ra_customer_trx_lines rlt1
2259: ,ar_vat_tax v1
2260: ,jl_zz_ar_tx_att_cls tcl1
2261: ,jl_zz_ar_tx_categ tc1
2262: WHERE r1.customer_trx_id = rl1.customer_trx_id
2263: AND r1.related_customer_trx_id = p_prev_cust_trx_id
2264: AND rl1.line_type = 'LINE'
2265: AND r1.customer_trx_id = rlt1.customer_trx_id

Line 2294: ,jl_zz_ar_tx_categ tc1

2290: ,ra_customer_trx_lines rl1
2291: ,ra_customer_trx_lines rlt1
2292: ,ar_vat_tax v1
2293: ,jl_zz_ar_tx_att_cls tcl1
2294: ,jl_zz_ar_tx_categ tc1
2295: WHERE r1.customer_trx_id = rl1.customer_trx_id
2296: AND r1.previous_customer_trx_id = p_prev_cust_trx_id
2297: AND r1.customer_trx_id <> p_curr_cust_trx_id
2298: AND rl1.line_type = 'LINE'

Line 2328: ,jl_zz_ar_tx_categ tc1

2324: ,ra_customer_trx_lines rl1
2325: ,ra_customer_trx_lines rlt1
2326: ,ar_vat_tax v1
2327: ,jl_zz_ar_tx_att_cls tcl1
2328: ,jl_zz_ar_tx_categ tc1
2329: WHERE r2.related_customer_trx_id = p_prev_cust_trx_id
2330: AND r2.customer_trx_id = r1.previous_customer_trx_id
2331: AND r1.customer_trx_id = rl1.customer_trx_id
2332: AND rl1.line_type = 'LINE'

Line 2367: ,jl_zz_ar_tx_categ tc1

2363: ,ra_customer_trx_lines rl1
2364: ,ra_customer_trx_lines rlt1
2365: ,ar_vat_tax v1
2366: ,jl_zz_ar_tx_att_cls tcl1
2367: ,jl_zz_ar_tx_categ tc1
2368: WHERE r1.customer_trx_id = rl1.customer_trx_id
2369: AND r1.customer_trx_id = p_rel_cust_trx_id
2370: AND rl1.line_type = 'LINE'
2371: AND r1.customer_trx_id = rlt1.customer_trx_id

Line 2400: ,jl_zz_ar_tx_categ tc1

2396: ,ra_customer_trx_lines rl1
2397: ,ra_customer_trx_lines rlt1
2398: ,ar_vat_tax v1
2399: ,jl_zz_ar_tx_att_cls tcl1
2400: ,jl_zz_ar_tx_categ tc1
2401: WHERE r1.customer_trx_id = rl1.customer_trx_id
2402: AND r1.related_customer_trx_id = p_rel_cust_trx_id
2403: AND rl1.line_type = 'LINE'
2404: AND r1.customer_trx_id = rlt1.customer_trx_id

Line 2433: ,jl_zz_ar_tx_categ tc1

2429: ,ra_customer_trx_lines rl1
2430: ,ra_customer_trx_lines rlt1
2431: ,ar_vat_tax v1
2432: ,jl_zz_ar_tx_att_cls tcl1
2433: ,jl_zz_ar_tx_categ tc1
2434: WHERE r1.customer_trx_id = rl1.customer_trx_id
2435: AND r1.previous_customer_trx_id = p_rel_cust_trx_id
2436: AND rl1.line_type = 'LINE'
2437: AND r1.customer_trx_id = rlt1.customer_trx_id

Line 2467: ,jl_zz_ar_tx_categ tc1

2463: ,ra_customer_trx_lines rl1
2464: ,ra_customer_trx_lines rlt1
2465: ,ar_vat_tax v1
2466: ,jl_zz_ar_tx_att_cls tcl1
2467: ,jl_zz_ar_tx_categ tc1
2468: WHERE r2.related_customer_trx_id = p_rel_cust_trx_id
2469: AND r2.customer_trx_id = r1.previous_customer_trx_id
2470: AND r1.customer_trx_id = rl1.customer_trx_id
2471: AND rl1.line_type = 'LINE'

Line 2501: ,jl_zz_ar_tx_categ tc1

2497: ,ra_customer_trx_lines rl1
2498: ,ra_customer_trx_lines rlt1
2499: ,ar_vat_tax v1
2500: ,jl_zz_ar_tx_att_cls tcl1
2501: ,jl_zz_ar_tx_categ tc1
2502: WHERE r1.customer_trx_id = rl1.customer_trx_id
2503: AND r1.customer_trx_id = p_curr_cust_trx_id
2504: AND rl1.line_type = 'LINE'
2505: AND r1.customer_trx_id = rlt1.customer_trx_id

Line 2525: ,jl_zz_ar_tx_categ tc1

2521: cursor rel_trx_categ is
2522: SELECT tc1.tax_category_id tax_category_id
2523: FROM ra_customer_trx_lines rlt1
2524: ,ar_vat_tax v1
2525: ,jl_zz_ar_tx_categ tc1
2526: WHERE rlt1.customer_trx_id = p_rel_cust_trx_id
2527: AND rlt1.line_type= 'TAX'
2528: AND rlt1.vat_tax_id = v1.vat_tax_id
2529: AND v1.tax_type = 'VAT'

Line 2537: ,jl_zz_ar_tx_categ tc1

2533: cursor cur_trx_categ is
2534: SELECT tc1.tax_category_id tax_category_id
2535: FROM ra_customer_trx_lines rlt1
2536: ,ar_vat_tax v1
2537: ,jl_zz_ar_tx_categ tc1
2538: WHERE rlt1.customer_trx_id = p_curr_cust_trx_id
2539: AND rlt1.line_type= 'TAX'
2540: AND rlt1.vat_tax_id = v1.vat_tax_id
2541: AND v1.tax_type = 'VAT'

Line 2917: FROM jl_zz_ar_tx_categ

2913: SELECT threshold_check_grp_by,
2914: threshold_check_level
2915: INTO l_grp_attr_name,
2916: l_operation_level
2917: FROM jl_zz_ar_tx_categ
2918: WHERE tax_category_id = p_tax_category_id
2919: AND p_trx_date BETWEEN NVL(start_date_active,p_trx_date)
2920: AND end_date_active;
2921: EXCEPTION

Line 3383: FROM jl_zz_ar_tx_categ tc,

3379: v_tax_category_to_reduce_id,
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)

Line 3448: from jl_zz_ar_tx_categ cat

3444: and ac.tax_attribute_type = 'ORGANIZATION_ATTRIBUTE'
3445: and ac.tax_attr_class_type = 'ORGANIZATION_CLASS'
3446: and ac.enabled_flag = 'Y'
3447: and exists (select 1
3448: from jl_zz_ar_tx_categ cat
3449: where cat.tax_category_id = ac.tax_category_id
3450: and ac.tax_attribute_name = cat.org_tax_attribute
3451: and p_trx_date <= cat.end_date_active
3452: and p_trx_date >= NVL(cat.start_date_active, p_trx_date));

Line 3475: from jl_zz_ar_tx_categ cat

3471: and ac.tax_attribute_type = 'TRANSACTION_ATTRIBUTE'
3472: and ac.tax_attr_class_type = 'TRANSACTION_CLASS'
3473: and ac.enabled_flag = 'Y'
3474: and exists (select 1
3475: from jl_zz_ar_tx_categ cat
3476: where cat.tax_category_id = ac.tax_category_id
3477: and ac.tax_attribute_name = cat.txn_tax_attribute
3478: and p_trx_date <= cat.end_date_active
3479: and p_trx_date >= NVL(cat.start_date_active, p_trx_date));

Line 3500: jl_zz_ar_tx_categ cat

3496: select ac.tax_attribute_value
3497: into v_aux_contributor_type
3498: from jl_zz_ar_tx_cus_cls ac,
3499: hz_cust_site_uses su,
3500: jl_zz_ar_tx_categ cat
3501: where ac.tax_attr_class_code = p_contributor_class
3502: and ac.tax_category_id = v_tax_category_to_reduce_id
3503: and ac.enabled_flag = 'Y'
3504: and cat.tax_category_id = ac.tax_category_id

Line 3515: jl_zz_ar_tx_categ cat

3511: ELSE
3512: select ac.tax_attribute_value
3513: into v_aux_contributor_type
3514: from jl_zz_ar_tx_att_cls ac,
3515: jl_zz_ar_tx_categ cat
3516: where ac.tax_attr_class_code = p_contributor_class
3517: and ac.tax_category_id = v_tax_category_to_reduce_id
3518: and ac.enabled_flag = 'Y'
3519: and ac.tax_attr_class_type = 'CONTRIBUTOR_CLASS'