APPS.JAI_GST_GENERAL_PKG dependencies on JAI_CMN_TAXES_ALL

Line 1179: FROM jai_cmn_taxes_all

1175: ) RETURN VARCHAR2 IS
1176:
1177: CURSOR c_get_tax_code(pn_tax_id IN NUMBER) IS
1178: SELECT tax_name
1179: FROM jai_cmn_taxes_all
1180: WHERE tax_id = pn_tax_id;
1181:
1182: ln_tax_code jai_cmn_taxes_all.tax_name%TYPE;
1183: v_debug char(1);

Line 1182: ln_tax_code jai_cmn_taxes_all.tax_name%TYPE;

1178: SELECT tax_name
1179: FROM jai_cmn_taxes_all
1180: WHERE tax_id = pn_tax_id;
1181:
1182: ln_tax_code jai_cmn_taxes_all.tax_name%TYPE;
1183: v_debug char(1);
1184:
1185: BEGIN
1186: v_debug := jai_constants.NO;

Line 1211: FROM jai_cmn_taxes_all

1207: ) RETURN NUMBER IS
1208:
1209: CURSOR c_get_tax_type_code(pn_tax_id IN NUMBER) IS
1210: SELECT tax_type
1211: FROM jai_cmn_taxes_all
1212: WHERE tax_id = pn_tax_id;
1213:
1214: ln_tax_type_code jai_cmn_taxes_all.tax_type%TYPE;
1215: v_debug char(1);

Line 1214: ln_tax_type_code jai_cmn_taxes_all.tax_type%TYPE;

1210: SELECT tax_type
1211: FROM jai_cmn_taxes_all
1212: WHERE tax_id = pn_tax_id;
1213:
1214: ln_tax_type_code jai_cmn_taxes_all.tax_type%TYPE;
1215: v_debug char(1);
1216:
1217:
1218: BEGIN

Line 1248: ln_tax_type_id jai_cmn_taxes_all.tax_type_id%TYPE;

1244: SELECT regime_id
1245: FROM jai_cmn_tax_types_all
1246: WHERE tax_type_code = cn_tax_type_code;
1247:
1248: ln_tax_type_id jai_cmn_taxes_all.tax_type_id%TYPE;
1249: ln_tax_regim_id jai_cmn_tax_types_all.regime_id%TYPE;
1250: v_debug char(1);
1251: BEGIN
1252: v_debug := jai_constants.NO;