DBA Data[Home] [Help]

APPS.IGS_EN_ELGBL_OVERRIDE dependencies on IGS_EN_STDNT_PS_ATT

Line 144: FROM igs_en_stdnt_ps_att sca

140: CURSOR cur_criteria_satisfied(p_course_cd VARCHAR2,p_course_version NUMBER,p_unit_cd VARCHAR2, p_unit_version NUMBER,
141: p_unit_set_cd VARCHAR2,p_unit_set_version NUMBER, p_org_unit_start_dt DATE,
142: p_load_cal_type VARCHAR2, p_load_cal_seq NUMBER) IS
143: SELECT DISTINCT(sca.person_id) person_id
144: FROM igs_en_stdnt_ps_att sca
145: WHERE (p_person_id IS NULL OR
146: sca.person_id = p_person_id) AND
147: (p_person_id_group IS NULL OR
148: EXISTS ( SELECT 'x'