APPS.JAI_CMN_MTAX_PKG dependencies on JAI_CMN_TAXES_ALL

Line 385: from JAI_CMN_TAX_CTG_LINES a, JAI_CMN_TAXES_ALL b

381: a.precedence_10 p_10,
382: b.tax_rate, b.tax_amount, b.uom_code, b.end_date valid_date,
383: -- DECODE(UPPER(b.tax_type), 'EXCISE', 1, 'ADDL. EXCISE', 1, 'OTHER EXCISE', 1, 'CVD', 1, jai_constants.tax_type_exc_edu_cess,1, 'TDS', 2, 0) tax_type_val,
384: b.mod_cr_percentage, b.vendor_id, b.tax_type, nvl(b.rounding_factor,0) rounding_factor
385: from JAI_CMN_TAX_CTG_LINES a, JAI_CMN_TAXES_ALL b
386: WHERE a.tax_category_id = p_tax_category_id
387: AND a.tax_id = b.tax_id
388: ORDER BY a.line_no;
389:

Line 1540: JAI_CMN_TAXES_ALL B

1536: A.creation_date,A.created_by,
1537: A.last_update_date, A.last_updated_by,A.last_update_login
1538: FROM
1539: JAI_PO_TAXES A,
1540: JAI_CMN_TAXES_ALL B
1541: WHERE
1542: A.tax_id = B.tax_id AND
1543: line_focus_id = shipment_rec.line_focus_id AND
1544: NVL(adhoc_flag,'N') = 'Y';

Line 2104: JAI_CMN_TAXES_ALL B

2100: A.creation_date,A.created_by,
2101: A.last_update_date, A.last_updated_by,A.last_update_login
2102: FROM
2103: JAI_PO_TAXES A,
2104: JAI_CMN_TAXES_ALL B
2105: WHERE
2106: A.tax_id = B.tax_id AND
2107: line_focus_id = releases_rec.line_focus_id AND
2108: NVL(adhoc_flag,'N') = 'Y';

Line 2672: JAI_CMN_TAXES_ALL B

2668: A.creation_date,A.created_by,
2669: A.last_update_date, A.last_updated_by,A.last_update_login
2670: FROM
2671: JAI_PO_REQ_LINE_TAXES A,
2672: JAI_CMN_TAXES_ALL B
2673: WHERE
2674: A.tax_id = B.tax_id AND
2675: requisition_line_id = reqn_rec.requisition_line_id AND
2676: NVL(adhoc_flag,'N') = 'Y' ;

Line 3190: JAI_CMN_TAXES_ALL B

3186: A.creation_date,A.created_by,
3187: A.last_update_date, A.last_updated_by,A.last_update_login
3188: FROM
3189: JAI_OM_OE_SO_TAXES A,
3190: JAI_CMN_TAXES_ALL B
3191: WHERE
3192: A.tax_id = B.tax_id AND
3193: line_id = so_rec.line_id AND
3194: NVL(adhoc_flag,'N') = 'Y';