APPS.IGS_PE_GEN_002 dependencies on IGS_PE_PERSON_BASE_V

Line 221: CURSOR c_student_chk (cp_person_number igs_pe_person_base_v.person_number%TYPE) IS

217: email_address IS NOT NULL AND
218: person_party_id IS NOT NULL;
219:
220: -- student check cursor
221: CURSOR c_student_chk (cp_person_number igs_pe_person_base_v.person_number%TYPE) IS
222: SELECT
223: person_id,NVL(full_name,person_number) full_name
224: FROM
225: igs_pe_person_base_v

Line 225: igs_pe_person_base_v

221: CURSOR c_student_chk (cp_person_number igs_pe_person_base_v.person_number%TYPE) IS
222: SELECT
223: person_id,NVL(full_name,person_number) full_name
224: FROM
225: igs_pe_person_base_v
226: WHERE
227: person_number = cp_person_number;
228:
229: -- hold type exists check cursor

Line 241: CURSOR c_hold_alrdy_exst(cp_person_id igs_pe_person_base_v.person_id%TYPE,

237: s_encumbrance_cat = 'ADMIN';
238:
239: -- check whether release hold should be called or apply hold should be called
240: -- change view IGS_PE_PERS_ENCUMB from igs_pe_pers_pen_encumb_v
241: CURSOR c_hold_alrdy_exst(cp_person_id igs_pe_person_base_v.person_id%TYPE,
242: cp_encumbrance_type igs_pe_pers_encumb_v.encumbrance_type%TYPE,
243: cp_start_dt DATE) IS
244: SELECT
245: expiry_dt

Line 255: CURSOR c_external_hold_exst(cp_person_id igs_pe_person_base_v.person_id%TYPE,

251: start_dt = cp_start_dt;
252:
253: -- check for mismatch of external ref passed
254: -- remove reference to the view.
255: CURSOR c_external_hold_exst(cp_person_id igs_pe_person_base_v.person_id%TYPE,
256: cp_encumbrance_type igs_pe_pers_encumb_v.encumbrance_type%TYPE,
257: cp_start_dt DATE,
258: cp_external_reference igs_pe_pers_encumb_v.external_reference%TYPE) IS
259: SELECT

Line 291: l_person_name igs_pe_person_base_v.full_name%TYPE;

287: l_d_expiry_date DATE := NULL;
288:
289: l_external_ref igs_pe_pers_encumb.external_reference%TYPE;
290: l_admin fnd_user.user_name%TYPE;
291: l_person_name igs_pe_person_base_v.full_name%TYPE;
292:
293:
294: l_student_rec c_student_chk%ROWTYPE;
295: l_message_name VARCHAR2(2000);