APPS.JAI_CMN_RGM_TAX_DIST_PKG dependencies on JAI_RGM_DIS_DES_TAXES

Line 2234: FROM JAI_RGM_DIS_DES_TAXES

2230:
2231: -- abcd
2232: CURSOR c_get_transfer_Dest_id IS
2233: SELECT transfer_Destination_id
2234: FROM JAI_RGM_DIS_DES_TAXES
2235: WHERE transfer_destination_line_id = p_reference_id;
2236:
2237: CURSOR c_cess_amt(cp_transfer_dest_id number) IS
2238: SELECT transfer_amount

Line 2239: FROM JAI_RGM_DIS_DES_TAXES

2235: WHERE transfer_destination_line_id = p_reference_id;
2236:
2237: CURSOR c_cess_amt(cp_transfer_dest_id number) IS
2238: SELECT transfer_amount
2239: FROM JAI_RGM_DIS_DES_TAXES
2240: WHERE transfer_destination_id = cp_transfer_dest_id
2241: -- 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
2242: --commented the above and added the below by Sanjikum for Bug#6119459
2243: and tax_type in ('EXCISE-CESS','SERVICE_EDUCATION_CESS');

Line 2248: FROM jai_rgm_dis_des_taxes

2244:
2245: --Added the below by kunkumar for bug#6127194
2246: CURSOR c_sh_cess_amt(cp_transfer_dest_id number) IS
2247: SELECT transfer_amount
2248: FROM jai_rgm_dis_des_taxes
2249: WHERE transfer_destination_id = cp_transfer_dest_id
2250: and tax_type in ('SERVICE_SH_EDU_CESS','EXCISE_SH_EDU_CESS');
2251: /* bug 13534704 */
2252: cursor c_get_src_rec ( cp_transfer_id jai_rgm_dis_src_hdrs.transfer_id%type

Line 2272: JAI_RGM_DIS_DES_TAXES_S.nextval ,

2268:
2269: SELECT jai_rgm_dis_src_hdrs_s.nextval ,
2270: JAI_RGM_DIS_SRC_TAXES_S.nextval ,
2271: jai_rgm_dis_des_hdrs_s.nextval ,
2272: JAI_RGM_DIS_DES_TAXES_S.nextval ,
2273: JAI_RGM_DIS_TRF_NUMS_S.nextval
2274: INTO ln_transfer_id ,
2275: ln_transfer_source_id ,
2276: ln_transfer_dest_id ,

Line 2374: INSERT INTO JAI_RGM_DIS_DES_TAXES

2370: sysdate ,
2371: fnd_global.user_id ,
2372: fnd_global.login_id
2373: );
2374: INSERT INTO JAI_RGM_DIS_DES_TAXES
2375: (
2376: TRANSFER_SOURCE_ID ,
2377: TRANSFER_DESTINATION_ID ,
2378: TRANSFER_DESTINATION_LINE_ID ,