APPS.IGS_AS_ADI_UPLD_AIO_PKG dependencies on IGS_EN_UNIT_SET

Line 16: v_unit_set_cd igs_en_unit_set.unit_set_cd%TYPE;

12: -- Set Attempts which have Selection and Requirements Complete/End Dates
13: -- which span the Census Date of the Teaching Period provided. If more than
14: -- one exists the one with the latest selection date will be returned
15: --
16: v_unit_set_cd igs_en_unit_set.unit_set_cd%TYPE;
17: --
18: --
19: --
20: CURSOR c_susa IS

Line 23: igs_en_unit_set us,

19: --
20: CURSOR c_susa IS
21: SELECT us.title
22: FROM igs_as_su_setatmpt susa,
23: igs_en_unit_set us,
24: igs_en_unit_set_cat usc
25: WHERE p_person_id = susa.person_id
26: AND p_course_cd = susa.course_cd
27: AND (igs_en_gen_015.get_effective_census_date (

Line 24: igs_en_unit_set_cat usc

20: CURSOR c_susa IS
21: SELECT us.title
22: FROM igs_as_su_setatmpt susa,
23: igs_en_unit_set us,
24: igs_en_unit_set_cat usc
25: WHERE p_person_id = susa.person_id
26: AND p_course_cd = susa.course_cd
27: AND (igs_en_gen_015.get_effective_census_date (
28: NULL,