APPS.JAI_AP_DTC_DEFAULTATION_PKG dependencies on JAI_CMN_TAX_CTG_LINES

Line 451: -- cursor to fetch datas from JAI_CMN_TAX_CTG_LINES

447: WHERE lookup_type = 'JAI_TDS_SECTION_SERVICE'
448: --AND lookup_code = cp_section_code; -- commented out by zhiwei.xin for bug 13731393 on 29-Feb-2012
449: AND UPPER(lookup_code) = UPPER(cp_section_code); -- added by zhiwei.xin for bug 13731393 on 29-Feb-2012
450:
451: -- cursor to fetch datas from JAI_CMN_TAX_CTG_LINES
452: cursor c_get_tax_ctg_lines (cp_tax_ctg_id number)
453: is
454: SELECT *
455: FROM JAI_CMN_TAX_CTG_LINES

Line 455: FROM JAI_CMN_TAX_CTG_LINES

451: -- cursor to fetch datas from JAI_CMN_TAX_CTG_LINES
452: cursor c_get_tax_ctg_lines (cp_tax_ctg_id number)
453: is
454: SELECT *
455: FROM JAI_CMN_TAX_CTG_LINES
456: WHERE TAX_CATEGORY_ID = cp_tax_ctg_id
457: ORDER BY LINE_NO;
458:
459: -- cursor to get tax code details

Line 482: JAI_CMN_TAX_CTG_LINES jctcl,

478: )
479: is
480: SELECT '1'
481: FROM JAI_CMN_TAX_CTGS_ALL jctca,
482: JAI_CMN_TAX_CTG_LINES jctcl,
483: JAI_CMN_TAXES_ALL jcta
484: WHERE jctca.TAX_CATEGORY_ID = cp_tax_ctg_id
485: AND jctcl.TAX_CATEGORY_ID = jctca.TAX_CATEGORY_ID
486: AND jcta.TAX_ID = jctcl.TAX_ID