APPS.IGS_EN_GEN_003 dependencies on IGS_PE_PERS_PREFS

Line 521: v_person_prefs_rec IGS_PE_PERS_PREFS%ROWTYPE;

517: AS
518: BEGIN
519: DECLARE
520: v_person_id IGS_PE_PERSON.person_id%TYPE;
521: v_person_prefs_rec IGS_PE_PERS_PREFS%ROWTYPE;
522: CURSOR c_person(
523: cp_username IGS_PE_PERSON.oracle_username%TYPE) IS
524: SELECT person_id
525: FROM IGS_PE_PERSON

Line 530: FROM IGS_PE_PERS_PREFS

526: WHERE oracle_username = cp_username;
527: CURSOR c_person_prefs(
528: cp_person_id IGS_PE_PERSON.person_id%TYPE) IS
529: SELECT *
530: FROM IGS_PE_PERS_PREFS
531: WHERE person_id = cp_person_id;
532: BEGIN
533: -- this module gets the enrolment values for a IGS_PE_PERSON's preference
534: -- table