APPS.JAI_BOE_MIGRATION_PKG dependencies on JAI_CMN_TAXES_ALL

Line 838: jai_cmn_taxes_all b

834: ) IS
835: CURSOR tax_cnt_cur(v_tax_category_id NUMBER, v_tax_type VARCHAR2) IS
836: SELECT count(b.tax_id) cnt_tax
837: FROM jai_cmn_tax_ctg_lines jctl,
838: jai_cmn_taxes_all b
839: WHERE jctl.tax_category_id = v_tax_category_id
840: AND jctl.tax_id = b.tax_id
841: AND b.tax_type = v_tax_type;
842: CURSOR tax_cur(v_tax_category_id NUMBER, v_tax_type VARCHAR2) IS

Line 846: jai_cmn_taxes_all b

842: CURSOR tax_cur(v_tax_category_id NUMBER, v_tax_type VARCHAR2) IS
843: SELECT b.tax_id,
844: b.tax_name
845: FROM jai_cmn_tax_ctg_lines jctl,
846: jai_cmn_taxes_all b
847: WHERE jctl.tax_category_id = v_tax_category_id
848: AND jctl.tax_id = b.tax_id
849: AND b.tax_type = v_tax_type;
850:

Line 1244: jai_cmn_taxes_all b,

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
1247: AND jctl.tax_id = b.tax_id
1248: AND rttv.tax_type = b.tax_type

Line 1257: jai_cmn_taxes_all b,

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
1260: AND jctl.tax_id = b.tax_id
1261: AND rttv.tax_type = b.tax_type