APPS.IGS_ST_GEN_001 dependencies on IGS_ST_GOVT_STDNT_EN

Line 242: FROM IGS_ST_GOVT_STDNT_EN gse

238: BEGIN
239: DECLARE
240: CURSOR c_gse IS
241: SELECT 'x'
242: FROM IGS_ST_GOVT_STDNT_EN gse
243: WHERE gse.person_id = p_person_id AND
244: gse.course_cd = p_course_cd AND
245: gse.submission_yr = p_collection_yr - 1;
246: v_cge_exists VARCHAR2(1);

Line 344: FROM IGS_ST_GOVT_STDNT_EN gse

340: BEGIN
341: DECLARE
342: CURSOR c_gse IS
343: SELECT 'x'
344: FROM IGS_ST_GOVT_STDNT_EN gse
345: WHERE gse.person_id = p_person_id AND
346: gse.course_cd = p_course_cd AND
347: gse.submission_yr < p_collection_yr;
348: v_cge_exists VARCHAR2(1);

Line 770: v_comm_dt IGS_ST_GOVT_STDNT_EN.commencement_dt%TYPE;

766: RETURN DATE
767: AS
768: BEGIN
769: DECLARE
770: v_comm_dt IGS_ST_GOVT_STDNT_EN.commencement_dt%TYPE;
771: CURSOR c_gse IS
772: SELECT gse.commencement_dt
773: FROM IGS_ST_GOVT_STDNT_EN gse
774: WHERE gse.submission_yr < p_collection_yr AND

Line 773: FROM IGS_ST_GOVT_STDNT_EN gse

769: DECLARE
770: v_comm_dt IGS_ST_GOVT_STDNT_EN.commencement_dt%TYPE;
771: CURSOR c_gse IS
772: SELECT gse.commencement_dt
773: FROM IGS_ST_GOVT_STDNT_EN gse
774: WHERE gse.submission_yr < p_collection_yr AND
775: gse.submission_number = 1 AND -- enrolment file is only ever submission 1
776: gse.person_id = p_person_id AND
777: gse.course_cd = p_prev_course_cd AND