APPS.JAI_MTL_TRXS_PKG dependencies on JAI_CMN_FIN_YEARS

Line 519: l_fin_year JAI_CMN_FIN_YEARS.fin_year%TYPE;

515: l_division JAI_CMN_RG_I_TRXS.division_no%TYPE;
516: l_register_id JAI_CMN_RG_I_TRXS.register_id%TYPE;
517: l_register_id_ii JAI_CMN_RG_I_TRXS.register_id_part_ii%TYPE;
518: l_slno JAI_CMN_RG_I_TRXS.slno%TYPE;
519: l_fin_year JAI_CMN_FIN_YEARS.fin_year%TYPE;
520: l_register_type VARCHAR2(3);
521: l_excise_duty NUMBER;
522: l_additional_ed NUMBER;
523: l_other_ed NUMBER;

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

554: RAISE NO_DATA_FOUND;
555: END IF;
556: CLOSE organization_type_cur;
557:
558: stmt_name := 'Selecting fin_year from JAI_CMN_FIN_YEARS';
559: SELECT fin_year
560: INTO l_fin_year
561: FROM JAI_CMN_FIN_YEARS
562: WHERE organization_id = main_rec.to_organization

Line 561: FROM JAI_CMN_FIN_YEARS

557:
558: stmt_name := 'Selecting fin_year from JAI_CMN_FIN_YEARS';
559: SELECT fin_year
560: INTO l_fin_year
561: FROM JAI_CMN_FIN_YEARS
562: WHERE organization_id = main_rec.to_organization
563: AND fin_active_flag = 'Y';
564:
565: stmt_name := 'Opening excise_cur';