APPS.IGS_HE_SUSA_LGCY_PUB dependencies on IGS_LOOKUP_VALUES

Line 71: -- Check if the specified fte_calc_type is a valid value in igs_lookup_values

67:
68: l_ret_value VARCHAR2(1) := 'S';
69:
70:
71: -- Check if the specified fte_calc_type is a valid value in igs_lookup_values
72: -- with type IGS_HE_FTE_CALC_TYPE
73: CURSOR c_fte_calc_type IS
74: SELECT 'X'
75: FROM igs_lookup_values

Line 75: FROM igs_lookup_values

71: -- Check if the specified fte_calc_type is a valid value in igs_lookup_values
72: -- with type IGS_HE_FTE_CALC_TYPE
73: CURSOR c_fte_calc_type IS
74: SELECT 'X'
75: FROM igs_lookup_values
76: WHERE lookup_type = 'IGS_HE_FTE_CALC_TYPE'
77: AND lookup_code = p_hesa_susa_rec.fte_calc_type
78: AND enabled_flag='Y';
79: l_dummy VARCHAR2(1);