APPS.JAI_CMN_MTAX_PKG dependencies on JAI_CMN_TAXES_ALL

Line 413: jai_cmn_taxes_all ttype

409: cursor get_tax_rec(cn_boe_detail_id number)
410: is
411: select ttax.tax_id,ttype.tax_type from
412: jai_boe_detail_taxes ttax,
413: jai_cmn_taxes_all ttype
414: where ttax.boe_detail_id = cn_boe_detail_id
415: and ttax.tax_id = ttype.tax_id;
416:
417: ln_boe_amount number;

Line 428: jai_cmn_taxes_all ttype

424: ttax.tax_amount,
425: ttype.tax_type,
426: ttax.boe_flag
427: from jai_boe_detail_taxes ttax,
428: jai_cmn_taxes_all ttype
429:
430: where ttax.boe_detail_id = cn_boe_detail_id
431: --and ttax.boe_flag = 'Y'
432: and ttax.tax_id = ttype.tax_id;

Line 474: from JAI_CMN_TAX_CTG_LINES a, JAI_CMN_TAXES_ALL b

470: a.precedence_10 p_10,
471: b.tax_rate, b.tax_amount, b.uom_code, b.end_date valid_date,
472: -- 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,
473: b.mod_cr_percentage, b.vendor_id, b.tax_type, nvl(b.rounding_factor,0) rounding_factor
474: from JAI_CMN_TAX_CTG_LINES a, JAI_CMN_TAXES_ALL b
475: WHERE a.tax_category_id = p_tax_category_id
476: AND a.tax_id = b.tax_id
477: ORDER BY a.line_no;
478:

Line 1943: JAI_CMN_TAXES_ALL B

1939: A.creation_date,A.created_by,
1940: A.last_update_date, A.last_updated_by,A.last_update_login
1941: FROM
1942: JAI_PO_TAXES A,
1943: JAI_CMN_TAXES_ALL B
1944: WHERE
1945: A.tax_id = B.tax_id AND
1946: line_focus_id = shipment_rec.line_focus_id AND
1947: NVL(adhoc_flag,'N') = 'Y';

Line 2532: JAI_CMN_TAXES_ALL B

2528: A.creation_date,A.created_by,
2529: A.last_update_date, A.last_updated_by,A.last_update_login
2530: FROM
2531: JAI_PO_TAXES A,
2532: JAI_CMN_TAXES_ALL B
2533: WHERE
2534: A.tax_id = B.tax_id AND
2535: line_focus_id = releases_rec.line_focus_id AND
2536: NVL(adhoc_flag,'N') = 'Y';

Line 3126: JAI_CMN_TAXES_ALL B

3122: A.creation_date,A.created_by,
3123: A.last_update_date, A.last_updated_by,A.last_update_login
3124: FROM
3125: JAI_PO_REQ_LINE_TAXES A,
3126: JAI_CMN_TAXES_ALL B
3127: WHERE
3128: A.tax_id = B.tax_id AND
3129: requisition_line_id = reqn_rec.requisition_line_id AND
3130: NVL(adhoc_flag,'N') = 'Y' ;

Line 3677: JAI_CMN_TAXES_ALL B

3673: A.creation_date,A.created_by,
3674: A.last_update_date, A.last_updated_by,A.last_update_login
3675: FROM
3676: JAI_OM_OE_SO_TAXES A,
3677: JAI_CMN_TAXES_ALL B
3678: WHERE
3679: A.tax_id = B.tax_id AND
3680: line_id = so_rec.line_id AND
3681: NVL(adhoc_flag,'N') = 'Y';

Line 4300: JAI_CMN_TAXES_ALL B

4296: A.creation_date,A.created_by,
4297: A.last_update_date, A.last_updated_by,A.last_update_login
4298: FROM
4299: JAI_BOE_DETAIL_TAXES A,
4300: JAI_CMN_TAXES_ALL B
4301: WHERE
4302: A.tax_id = B.tax_id AND
4303: boe_detail_id = boe_rec.boe_detail_id AND
4304: NVL(adhoc_flag,'N') = 'Y';

Line 4347: from jai_cmn_taxes_all

4343:
4344:
4345:
4346: select inclusive_tax_flag into lv_inclusive_tax_flag
4347: from jai_cmn_taxes_all
4348: where tax_id = tax_rec.tax_id;
4349:
4350: IF(chk_boe_tax(tax_rec.tax_type) = 1)then
4351: