APPS.JAI_CMN_TAX_DEFAULTATION_PKG dependencies on JAI_CMN_TAX_CTG_LINES

Line 513: from JAI_CMN_TAX_CTG_LINES

509: */
510: cursor c_chk_tax_duplication
511: is
512: select 1
513: from JAI_CMN_TAX_CTG_LINES
514: where tax_category_id in (p_tax_category_id, nvl(p_threshold_tax_cat_id,-1))
515: group by tax_id
516: having count(tax_id) > 1;
517:

Line 521: from JAI_CMN_TAX_CTG_LINES cat

517:
518: cursor c_get_max_tax_line
519: is
520: select max(line_no) max_tax_line
521: from JAI_CMN_TAX_CTG_LINES cat
522: where cat.tax_category_id = p_tax_category_id;
523:
524: cursor c_get_max_rgm_tax_line
525: is

Line 527: from JAI_CMN_TAX_CTG_LINES cat, JAI_CMN_TAXES_ALL taxes

523:
524: cursor c_get_max_rgm_tax_line
525: is
526: select max(line_no) max_rgm_tax_line
527: from JAI_CMN_TAX_CTG_LINES cat, JAI_CMN_TAXES_ALL taxes
528: where cat.tax_category_id = p_tax_category_id
529: and taxes.tax_id = cat.tax_id
530: and taxes.tax_type = p_thhold_cat_base_tax_typ;
531:

Line 559: FROM JAI_CMN_TAX_CTG_LINES a, JAI_CMN_TAXES_ALL b ,

555: )
556: ) tax_type_val,
557: b.mod_cr_percentage, b.vendor_id, b.tax_type,nvl(b.rounding_factor,0) rounding_factor
558: , inclusive_tax_flag --added by walton for inclusive tax 08-Dev-07
559: FROM JAI_CMN_TAX_CTG_LINES a, JAI_CMN_TAXES_ALL b ,
560: jai_regime_tax_types_v rgm_tax_types /* added by ssumaith - bug# 4245053*/
561: WHERE a.tax_category_id = p_tax_category_id
562: AND rgm_tax_types.tax_type (+) = b.tax_type /* added by ssumaith - bug# 4245053*/
563: AND a.tax_id = b.tax_id

Line 4687: from JAI_CMN_TAX_CTG_LINES a

4683: , nvl(b.rounding_factor,0) rounding_factor
4684: , b.adhoc_flag
4685: , a.tax_category_id
4686: , b.inclusive_tax_flag --added by walton for inclusive tax on 08-Dev-07
4687: from JAI_CMN_TAX_CTG_LINES a
4688: , JAI_CMN_TAXES_ALL b
4689: , jai_regime_tax_types_v rgm_tax_types /* added by ssumaith - bug# 4245053*/
4690: where a.tax_category_id in (p_tax_category_id, nvl(p_threshold_tax_cat_id,-1))
4691: and rgm_tax_types.tax_type (+) = b.tax_type /* added by ssumaith - bug# 4245053*/

Line 4763: from JAI_CMN_TAX_CTG_LINES a

4759: , nvl(b.rounding_factor,0) rounding_factor
4760: , b.adhoc_flag
4761: , a.tax_category_id
4762: , b.inclusive_tax_flag --Add by Kevin Cheng
4763: from JAI_CMN_TAX_CTG_LINES a
4764: , JAI_CMN_TAXES_ALL b
4765: , jai_regime_tax_types_v rgm_tax_types /* added by ssumaith - bug# 4245053*/
4766: where a.tax_category_id in (p_tax_category_id, nvl(p_threshold_tax_cat_id,-1))
4767: and rgm_tax_types.tax_type (+) = b.tax_type /* added by ssumaith - bug# 4245053*/