APPS.IGF_GR_VERIFY_PROCESS dependencies on IGS_PE_PERSON_BASE_V

Line 138: person_number igs_pe_person_base_v.person_number%TYPE);

134:
135: TYPE c_pregrpcurtyp IS REF CURSOR ;
136: cur_per_grp c_pregrpcurtyp;
137: TYPE cpergrptyp IS RECORD ( person_id igf_ap_fa_base_rec_all.person_id%TYPE,
138: person_number igs_pe_person_base_v.person_number%TYPE);
139: per_grp_rec cpergrptyp ;
140:
141: l_c_ci_cal_type igf_ap_fa_base_rec.ci_cal_type%TYPE;
142: l_n_ci_sequence_number igf_ap_fa_base_rec.ci_sequence_number%TYPE;

Line 178: igs_pe_person_base_v

174: SELECT
175: person_id,
176: person_number
177: FROM
178: igs_pe_person_base_v
179: WHERE
180: person_id IN ('||l_c_sql_stmt||') ' USING p_n_per_grp_id;
181: ELSIF lv_group_type = 'DYNAMIC' THEN
182: OPEN cur_per_grp

Line 189: igs_pe_person_base_v

185: SELECT
186: person_id,
187: person_number
188: FROM
189: igs_pe_person_base_v
190: WHERE
191: person_id IN ('||l_c_sql_stmt||')
192: ';
193: END IF;