APPS.IGS_FI_PRC_DISC_SUA dependencies on IGS_PE_PERSON_BASE_V

Line 300: sapanigr 13-Feb-2006 Bug#5018036. Modified cursor cur_person. Query now uses igs_pe_person_base_v

296:
297: sapanigr 01-Jun-2006 Bug#5251760. Review comments addressed. Minor modifications.
298: sapanigr 31-May-2006 Bug#5251760. Removed unions in cur_person_unit_outstdng_chrgs to form
299: three separate cursors. Modified related code accordingly.
300: sapanigr 13-Feb-2006 Bug#5018036. Modified cursor cur_person. Query now uses igs_pe_person_base_v
301: instead of igs_pe_person.
302: rmaddipa 22-jul-2004 Bug#3776195 Replaced the call APP_EXCEPTION.RAISE_EXCEPTION with a
303: "retcode := 2;" statement and "RETURN;" to remove the 'Unhandled Exception'
304: in the log,

Line 434: CURSOR cur_person(cp_person_id IN igs_pe_person_base_v.person_id%TYPE) IS

430: BETWEEN wd.start_dt and wd.end_dt))
431: ORDER BY person_id,course_cd, uoo_id,invoice_creation_date;
432:
433: --Cursor to fetch the person details
434: CURSOR cur_person(cp_person_id IN igs_pe_person_base_v.person_id%TYPE) IS
435: SELECT person_number,
436: first_name || ' ' || last_name person_name
437: FROM igs_pe_person_base_v
438: WHERE person_id = cp_person_id;

Line 437: FROM igs_pe_person_base_v

433: --Cursor to fetch the person details
434: CURSOR cur_person(cp_person_id IN igs_pe_person_base_v.person_id%TYPE) IS
435: SELECT person_number,
436: first_name || ' ' || last_name person_name
437: FROM igs_pe_person_base_v
438: WHERE person_id = cp_person_id;
439:
440: -- Enh # 2187247
441: -- Modified the cursor for fetching the unit attempt status