2785: WHERE transaction_id = to_number(l_reference_1)
2786: AND set_of_books_id = g_set_of_books_id ;
2787:
2788: -- Get the Legislation Indicator Value from
2789: -- fv_be_transaction_types table.
2790: SELECT legislative_indicator
2791: INTO g_legis_ind_val
2792: FROM FV_be_transaction_types
2793: WHERE apprn_transaction_type = l_tran_type
2788: -- Get the Legislation Indicator Value from
2789: -- fv_be_transaction_types table.
2790: SELECT legislative_indicator
2791: INTO g_legis_ind_val
2792: FROM FV_be_transaction_types
2793: WHERE apprn_transaction_type = l_tran_type
2794: AND set_of_books_id = g_set_of_books_id ;
2795: EXCEPTION
2796: WHEN NO_DATA_FOUND THEN