APPS.JAI_BOE_MIGRATION_PKG dependencies on JAI_CMN_TAX_CTGS_ALL

Line 1137: FROM jai_cmn_tax_ctgs_all

1133: AND hdr.boe_id = ln_boe_id;
1134:
1135: CURSOR tax_category_cur(ln_tax_category_id NUMBER) IS
1136: SELECT org_id
1137: FROM jai_cmn_tax_ctgs_all
1138: WHERE tax_category_id = ln_tax_category_id;
1139:
1140: boe_rec boe_cur%ROWTYPE;
1141: ln_org_id_tax_category NUMBER;

Line 1242: FROM jai_cmn_tax_ctgs_all jitc,

1238: CURSOR tax_category_cur(ln_tax_category_id NUMBER) IS
1239: SELECT jitc.tax_category_id,
1240: jctl.tax_id, b.tax_type,
1241: rttv.regime_code
1242: FROM jai_cmn_tax_ctgs_all jitc,
1243: jai_cmn_tax_ctg_lines jctl,
1244: jai_cmn_taxes_all b,
1245: jai_regime_tax_types_v rttv
1246: WHERE jitc.tax_category_id = jctl.tax_category_id

Line 1255: FROM jai_cmn_tax_ctgs_all jitc,

1251: CURSOR tax_id_cnt_cur(ln_tax_category_id NUMBER) IS
1252: SELECT jitc.tax_category_id,
1253: b.tax_type,
1254: COUNT(jctl.tax_id) cnt_tax_id
1255: FROM jai_cmn_tax_ctgs_all jitc,
1256: jai_cmn_tax_ctg_lines jctl,
1257: jai_cmn_taxes_all b,
1258: jai_regime_tax_types_v rttv
1259: WHERE jitc.tax_category_id = jctl.tax_category_id