APPS.IGS_RU_GEN_001 dependencies on IGS_PE_PERSID_GROUP

Line 3026: FROM igs_pe_persid_group peg,igs_pe_prsid_grp_mem pegm

3022: l_tds r_tds ;
3023:
3024: CURSOR c_persid IS
3025: SELECT peg.group_cd
3026: FROM igs_pe_persid_group peg,igs_pe_prsid_grp_mem pegm
3027: WHERE peg.group_id = pegm.group_id
3028: AND pegm.person_id = p_person_id ;
3029:
3030: BEGIN

Line 4469: CURSOR CUR_PID IS SELECT G.GROUP_CD, PERSON_ID from IGS_PE_PRSID_GRP_MEM M, IGS_PE_PERSID_GROUP G WHERE

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
4469: CURSOR CUR_PID IS SELECT G.GROUP_CD, PERSON_ID from IGS_PE_PRSID_GRP_MEM M, IGS_PE_PERSID_GROUP G WHERE
4470: G.GROUP_ID = M.GROUP_ID AND SYSDATE BETWEEN M.START_DATE AND NVL(M.END_DATE, SYSDATE+1)
4471: AND M.PERSON_ID = P_PERSON_ID ;
4472:
4473: --Cursor to get all the unit sets attempted by the student

Line 4481: lv_Group_id IGS_PE_PERSID_GROUP.GROUP_CD%TYPE;

4477: -- nalkumar ** CURSOR CUR_GRD_RND IS select rpad(GRD_CAL_TYPE,10)||rpad(GRD_CI_SEQUENCE_NUMBER,6) GRAD_ROUND from IGS_GR_AWD_CRMN WHERE PERSON_ID = P_PERSON_ID ;
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);