APPS.JAI_CMN_TAX_DEFAULTATION_PKG dependencies on JAI_CMN_TAX_CTG_LINES

Line 464: from JAI_CMN_TAX_CTG_LINES

460: */
461: cursor c_chk_tax_duplication
462: is
463: select 1
464: from JAI_CMN_TAX_CTG_LINES
465: where tax_category_id in (p_tax_category_id, nvl(p_threshold_tax_cat_id,-1))
466: group by tax_id
467: having count(tax_id) > 1;
468:

Line 472: from JAI_CMN_TAX_CTG_LINES cat

468:
469: cursor c_get_max_tax_line
470: is
471: select max(line_no) max_tax_line
472: from JAI_CMN_TAX_CTG_LINES cat
473: where cat.tax_category_id = p_tax_category_id;
474:
475: cursor c_get_max_rgm_tax_line
476: is

Line 478: from JAI_CMN_TAX_CTG_LINES cat, JAI_CMN_TAXES_ALL taxes

474:
475: cursor c_get_max_rgm_tax_line
476: is
477: select max(line_no) max_rgm_tax_line
478: from JAI_CMN_TAX_CTG_LINES cat, JAI_CMN_TAXES_ALL taxes
479: where cat.tax_category_id = p_tax_category_id
480: and taxes.tax_id = cat.tax_id
481: and taxes.tax_type = p_thhold_cat_base_tax_typ;
482:

Line 507: FROM JAI_CMN_TAX_CTG_LINES a, JAI_CMN_TAXES_ALL b ,

503: )
504: ) tax_type_val,
505: b.mod_cr_percentage, b.vendor_id, b.tax_type,nvl(b.rounding_factor,0) rounding_factor
506: , inclusive_tax_flag --added by walton for inclusive tax 08-Dev-07
507: FROM JAI_CMN_TAX_CTG_LINES a, JAI_CMN_TAXES_ALL b ,
508: jai_regime_tax_types_v rgm_tax_types /* added by ssumaith - bug# 4245053*/
509: WHERE a.tax_category_id = p_tax_category_id
510: AND rgm_tax_types.tax_type (+) = b.tax_type /* added by ssumaith - bug# 4245053*/
511: AND a.tax_id = b.tax_id

Line 3450: from JAI_CMN_TAX_CTG_LINES a

3446: , nvl(b.rounding_factor,0) rounding_factor
3447: , b.adhoc_flag
3448: , a.tax_category_id
3449: , b.inclusive_tax_flag --added by walton for inclusive tax on 08-Dev-07
3450: from JAI_CMN_TAX_CTG_LINES a
3451: , JAI_CMN_TAXES_ALL b
3452: , jai_regime_tax_types_v rgm_tax_types /* added by ssumaith - bug# 4245053*/
3453: where a.tax_category_id in (p_tax_category_id, nvl(p_threshold_tax_cat_id,-1))
3454: and rgm_tax_types.tax_type (+) = b.tax_type /* added by ssumaith - bug# 4245053*/

Line 3523: from JAI_CMN_TAX_CTG_LINES a

3519: , nvl(b.rounding_factor,0) rounding_factor
3520: , b.adhoc_flag
3521: , a.tax_category_id
3522: , b.inclusive_tax_flag --Add by Kevin Cheng
3523: from JAI_CMN_TAX_CTG_LINES a
3524: , JAI_CMN_TAXES_ALL b
3525: , jai_regime_tax_types_v rgm_tax_types /* added by ssumaith - bug# 4245053*/
3526: where a.tax_category_id in (p_tax_category_id, nvl(p_threshold_tax_cat_id,-1))
3527: and rgm_tax_types.tax_type (+) = b.tax_type /* added by ssumaith - bug# 4245053*/