APPS.IGS_RU_GEN_001 dependencies on IGS_PS_VER

Line 699: FROM IGS_PS_VER_RU

695: v_rule_number NUMBER;
696: BEGIN
697: SELECT rul_sequence_number
698: INTO v_rule_number
699: FROM IGS_PS_VER_RU
700: WHERE course_cd = p_course_cd
701: AND version_number = p_version
702: AND s_rule_call_cd = p_rule_call_name;
703: RETURN v_rule_number;

Line 3282: FROM IGS_PS_VER

3278: CURSOR cur_c1 (
3279: p_course_cd VARCHAR2,
3280: p_course_version NUMBER )IS
3281: SELECT max_cp_per_teaching_period
3282: FROM IGS_PS_VER
3283: WHERE course_cd = p_course_cd AND
3284: version_number = p_course_version;
3285:
3286: l_max_cp IGS_PS_VER.max_cp_per_teaching_period%Type;

Line 3286: l_max_cp IGS_PS_VER.max_cp_per_teaching_period%Type;

3282: FROM IGS_PS_VER
3283: WHERE course_cd = p_course_cd AND
3284: version_number = p_course_version;
3285:
3286: l_max_cp IGS_PS_VER.max_cp_per_teaching_period%Type;
3287:
3288: BEGIN
3289:
3290: OPEN cur_c1(p_course_cd,

Line 3495: FROM IGS_PS_VER

3491: LOOP
3492: FOR CRS IN (
3493: SELECT course_cd,
3494: version_number
3495: FROM IGS_PS_VER
3496: WHERE course_cd LIKE (set_members.unit_cd)
3497: ORDER BY course_cd,IGS_GE_NUMBER.TO_CANN(version_number) )
3498: LOOP
3499: IF in_versions(CRS.version_number,

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 4483: lv_org_unit IGS_PS_VER.RESPONSIBLE_ORG_UNIT_CD%TYPE;

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);
4487: