APPS.JAI_CMN_RGM_TAX_DIST_PKG dependencies on JAI_RGM_DIS_DES_TAXES

Line 1374: FROM JAI_RGM_DIS_DES_TAXES

1370:
1371: -- abcd
1372: CURSOR c_get_transfer_Dest_id IS
1373: SELECT transfer_Destination_id
1374: FROM JAI_RGM_DIS_DES_TAXES
1375: WHERE transfer_destination_line_id = p_reference_id;
1376:
1377: CURSOR c_cess_amt(cp_transfer_dest_id number) IS
1378: SELECT transfer_amount

Line 1379: FROM JAI_RGM_DIS_DES_TAXES

1375: WHERE transfer_destination_line_id = p_reference_id;
1376:
1377: CURSOR c_cess_amt(cp_transfer_dest_id number) IS
1378: SELECT transfer_amount
1379: FROM JAI_RGM_DIS_DES_TAXES
1380: WHERE transfer_destination_id = cp_transfer_dest_id
1381: -- and tax_type in (lv_excise_cess,jai_constants.tax_type_service_edu_cess, jai_constants.tax_type_sh_service_edu_cess); --rchandan for bug#4428980
1382: --commented the above and added the below by Sanjikum for Bug#6119459
1383: and tax_type in ('EXCISE-CESS','SERVICE_EDUCATION_CESS');

Line 1388: FROM jai_rgm_dis_des_taxes

1384:
1385: --Added the below by kunkumar for bug#6127194
1386: CURSOR c_sh_cess_amt(cp_transfer_dest_id number) IS
1387: SELECT transfer_amount
1388: FROM jai_rgm_dis_des_taxes
1389: WHERE transfer_destination_id = cp_transfer_dest_id
1390: and tax_type in ('SERVICE_SH_EDU_CESS','EXCISE_SH_EDU_CESS');
1391:
1392:

Line 1400: JAI_RGM_DIS_DES_TAXES_S.nextval ,

1396:
1397: SELECT jai_rgm_dis_src_hdrs_s.nextval ,
1398: JAI_RGM_DIS_SRC_TAXES_S.nextval ,
1399: jai_rgm_dis_des_hdrs_s.nextval ,
1400: JAI_RGM_DIS_DES_TAXES_S.nextval ,
1401: JAI_RGM_DIS_TRF_NUMS_S.nextval
1402: INTO ln_transfer_id ,
1403: ln_transfer_source_id ,
1404: ln_transfer_dest_id ,

Line 1502: INSERT INTO JAI_RGM_DIS_DES_TAXES

1498: sysdate ,
1499: fnd_global.user_id ,
1500: fnd_global.login_id
1501: );
1502: INSERT INTO JAI_RGM_DIS_DES_TAXES
1503: (
1504: TRANSFER_SOURCE_ID ,
1505: TRANSFER_DESTINATION_ID ,
1506: TRANSFER_DESTINATION_LINE_ID ,