APPS.IGS_RU_GEN_001 dependencies on IGS_EN_STDNT_PS_ATT

Line 4464: FROM igs_en_stdnt_ps_att pa, igs_ps_ver pv

4460: -- Cursor to get the Progression status of the student This will return only one row: since there is a join based on person ID and Course Code
4461: -- nalkumar ** CURSOR CUR_PRG_STAT IS SELECT PV.RESPONSIBLE_ORG_UNIT_CD, PA.PROGRESSION_STATUS FROM
4462: CURSOR cur_prg_stat IS
4463: SELECT pa.progression_status, pv.responsible_org_unit_cd
4464: FROM igs_en_stdnt_ps_att pa, igs_ps_ver pv
4465: WHERE pv.course_cd = pa.course_cd and pv.version_number = pa.version_number and pa.person_id = p_person_id and pa.course_cd = p_course_cd;
4466:
4467:
4468: -- CURSOR TO SELECT THE PERSON id GROUPS TO WHICH THE STUDENT BELONGS

Line 4482: lv_progression_status IGS_EN_STDNT_PS_ATT_ALL.PROGRESSION_STATUS%TYPE;

4478: CURSOR CUR_GRD_RND IS select GRD_CAL_TYPE||GRD_CI_SEQUENCE_NUMBER GRAD_ROUND from IGS_GR_AWD_CRMN WHERE PERSON_ID = P_PERSON_ID ;
4479:
4480:
4481: lv_Group_id IGS_PE_PERSID_GROUP.GROUP_CD%TYPE;
4482: lv_progression_status IGS_EN_STDNT_PS_ATT_ALL.PROGRESSION_STATUS%TYPE;
4483: lv_org_unit IGS_PS_VER.RESPONSIBLE_ORG_UNIT_CD%TYPE;
4484: lv_Unit_set_cd IGS_AS_SU_SETATMPT.UNIT_SET_CD%TYPE;
4485: lv_att_type VARCHAR2(30);
4486: lv_class_standing varchar2(30);