APPS.IGI_EXP_UTILS dependencies on IGI_EXP_NUM_SCHEMES

Line 24: FROM igi_exp_num_schemes

20: SELECT num_scheme_id,
21: prefix,
22: suffix,
23: next_seq_val
24: FROM igi_exp_num_schemes
25: WHERE numbering_type = pi_number_type
26: AND numbering_class = pi_number_class
27: AND du_tu_type_id = pi_du_tu_type_id
28: AND fiscal_year = pi_fiscal_year

Line 84: UPDATE igi_exp_num_schemes_all

80: --
81: -- Update Next Sequence Value
82: --
83:
84: UPDATE igi_exp_num_schemes_all
85: SET next_seq_val = (next_seq_val + 1)
86: WHERE num_scheme_id = l_num_scheme_id;
87:
88: --