APPS.IGF_AW_LOCK_ASSGN_PKG dependencies on IGS_PE_PERSON_BASE_V

Line 47: person_number igs_pe_person_base_v.person_number%TYPE

43: cur_per_grp CpregrpCurTyp ;
44:
45: TYPE CpergrpTyp IS RECORD(
46: person_id igf_ap_fa_base_rec_all.person_id%TYPE,
47: person_number igs_pe_person_base_v.person_number%TYPE
48: );
49: per_grp_rec CpergrpTyp ;
50:
51:

Line 222: FROM igs_pe_person_base_v

218: IF lv_group_type = 'STATIC' THEN
219: OPEN cur_per_grp FOR
220: 'SELECT person_id,
221: person_number
222: FROM igs_pe_person_base_v
223: WHERE person_id IN ('||lv_sql_stmt||') ' USING p_pid_group;
224: ELSIF lv_group_type = 'DYNAMIC' THEN
225: OPEN cur_per_grp FOR
226: 'SELECT person_id,

Line 228: FROM igs_pe_person_base_v

224: ELSIF lv_group_type = 'DYNAMIC' THEN
225: OPEN cur_per_grp FOR
226: 'SELECT person_id,
227: person_number
228: FROM igs_pe_person_base_v
229: WHERE person_id IN ('||lv_sql_stmt||')';
230: END IF;
231:
232: FETCH cur_per_grp INTO per_grp_rec;