APPS.IGS_OR_INST_IMP_003_PKG dependencies on IGS_LOOKUP_VALUES

Line 1171: cp_lookup_type igs_lookup_values.lookup_type%TYPE,

1167: oss_stat_det_rec cur_get_oss_stat_det%ROWTYPE;
1168:
1169: --cursor to do field level validation before importing data into statistics master
1170: CURSOR c_val_stat(p_stat_type_cd igs_or_inst_stat_int.stat_type_cd%TYPE,
1171: cp_lookup_type igs_lookup_values.lookup_type%TYPE,
1172: cp_enabled_flag igs_lookup_values.enabled_flag%TYPE) IS
1173: SELECT 'X'
1174: FROM igs_lookup_values lkv
1175: WHERE lkv.lookup_code = p_stat_type_cd

Line 1172: cp_enabled_flag igs_lookup_values.enabled_flag%TYPE) IS

1168:
1169: --cursor to do field level validation before importing data into statistics master
1170: CURSOR c_val_stat(p_stat_type_cd igs_or_inst_stat_int.stat_type_cd%TYPE,
1171: cp_lookup_type igs_lookup_values.lookup_type%TYPE,
1172: cp_enabled_flag igs_lookup_values.enabled_flag%TYPE) IS
1173: SELECT 'X'
1174: FROM igs_lookup_values lkv
1175: WHERE lkv.lookup_code = p_stat_type_cd
1176: AND lkv.lookup_type= cp_lookup_type

Line 1174: FROM igs_lookup_values lkv

1170: CURSOR c_val_stat(p_stat_type_cd igs_or_inst_stat_int.stat_type_cd%TYPE,
1171: cp_lookup_type igs_lookup_values.lookup_type%TYPE,
1172: cp_enabled_flag igs_lookup_values.enabled_flag%TYPE) IS
1173: SELECT 'X'
1174: FROM igs_lookup_values lkv
1175: WHERE lkv.lookup_code = p_stat_type_cd
1176: AND lkv.lookup_type= cp_lookup_type
1177: AND enabled_flag = cp_enabled_flag;
1178: