APPS.JAI_AP_UTILS_PKG dependencies on JAI_CMN_TAXES_ALL_S

Line 3786: SELECT JAI_CMN_TAXES_ALL_S.nextval

3782: / (ln_base_tax_rate + NVL(tax_code_info_rec.cess_rate,0) + NVL(tax_code_info_rec.sh_cess_rate,0)), 2);
3783:
3784: --@Create new tax code for base TDS tax
3785: --get tax code ID for base tax
3786: SELECT JAI_CMN_TAXES_ALL_S.nextval
3787: INTO ln_base_tax_id
3788: FROM dual;
3789:
3790: ln_prcd_cnt := 1;

Line 3832: SELECT JAI_CMN_TAXES_ALL_S.nextval

3828: jai_cmn_tax_ctg_lines_rec.last_update_login := fnd_global.login_id;
3829: insert_jai_cmn_tax_ctg_lines(jai_cmn_tax_ctg_lines_rec);
3830:
3831: --get tax code ID for base tax
3832: SELECT JAI_CMN_TAXES_ALL_S.nextval
3833: INTO ln_cess_id
3834: FROM dual;
3835:
3836: IF NVL(ln_cess_rate,0) <> 0 THEN

Line 3839: SELECT JAI_CMN_TAXES_ALL_S.nextval

3835:
3836: IF NVL(ln_cess_rate,0) <> 0 THEN
3837: ln_prcd_cnt := ln_prcd_cnt + 1;
3838: --get tax code ID for TDS CESS tax
3839: SELECT JAI_CMN_TAXES_ALL_S.nextval
3840: INTO ln_cess_id
3841: FROM dual;
3842:
3843: lv_name := SUBSTR(ln_cess_rate || '% TDS CESS migrated from: ' || tax_code_info_rec.tax_id || '-' || tax_code_info_rec.tax_name,1,100);

Line 3887: SELECT JAI_CMN_TAXES_ALL_S.nextval

3883:
3884: IF NVL(ln_sh_cess_rate,0) <> 0 THEN
3885: ln_prcd_cnt := ln_prcd_cnt + 1;
3886: --get tax code ID for TDS CESS tax
3887: SELECT JAI_CMN_TAXES_ALL_S.nextval
3888: INTO ln_sh_cess_id
3889: FROM dual;
3890:
3891: lv_name := SUBSTR(ln_sh_cess_rate || '% TDS SH CESS migrated from: ' || tax_code_info_rec.tax_id || '-' || tax_code_info_rec.tax_name,1,100);

Line 3939: SELECT JAI_CMN_TAXES_ALL_S.nextval

3935:
3936: IF NVL(ln_surcharge_rate,0) <> 0 THEN
3937: ln_prcd_cnt := ln_prcd_cnt + 1;
3938: --get tax code ID for TDS CESS tax
3939: SELECT JAI_CMN_TAXES_ALL_S.nextval
3940: INTO ln_surcharge_id
3941: FROM dual;
3942:
3943: lv_name := SUBSTR(ln_surcharge_rate || '% TDS surcharge migrated from: ' || tax_code_info_rec.tax_id || '-' || tax_code_info_rec.tax_name,1,100);