APPS.JAI_MTL_TRXS_PKG dependencies on JAI_CMN_FIN_YEARS

Line 396: l_fin_year JAI_CMN_FIN_YEARS.fin_year%TYPE;

392: l_division JAI_CMN_RG_I_TRXS.division_no%TYPE;
393: l_register_id JAI_CMN_RG_I_TRXS.register_id%TYPE;
394: l_register_id_ii JAI_CMN_RG_I_TRXS.register_id_part_ii%TYPE;
395: l_slno JAI_CMN_RG_I_TRXS.slno%TYPE;
396: l_fin_year JAI_CMN_FIN_YEARS.fin_year%TYPE;
397: l_register_type VARCHAR2(3);
398: l_excise_duty NUMBER;
399: l_additional_ed NUMBER;
400: l_other_ed NUMBER;

Line 435: stmt_name := 'Selecting fin_year from JAI_CMN_FIN_YEARS';

431: RAISE NO_DATA_FOUND;
432: END IF;
433: CLOSE organization_type_cur;
434:
435: stmt_name := 'Selecting fin_year from JAI_CMN_FIN_YEARS';
436: SELECT fin_year
437: INTO l_fin_year
438: FROM JAI_CMN_FIN_YEARS
439: WHERE organization_id = main_rec.to_organization

Line 438: FROM JAI_CMN_FIN_YEARS

434:
435: stmt_name := 'Selecting fin_year from JAI_CMN_FIN_YEARS';
436: SELECT fin_year
437: INTO l_fin_year
438: FROM JAI_CMN_FIN_YEARS
439: WHERE organization_id = main_rec.to_organization
440: AND fin_active_flag = 'Y';
441:
442: stmt_name := 'Opening excise_cur';