eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_EN_NSC_PKG dependencies on IGS_EN_STDNT_PS_ATT

Line 276: FROM igs_en_stdnt_ps_Att spa , igs_ps_ver vers, hz_parties hp, igs_pe_hz_parties ihp,

272: --such that they belong to the local institution .
273:
274: CURSOR c_course (cp_nslc_condition VARCHAR2 )IS
275: SELECT DISTINCT spa.course_cd, spa.version_number, hp.party_id org_id, ihp.oss_org_unit_cd org_unit_cd
276: FROM igs_en_stdnt_ps_Att spa , igs_ps_ver vers, hz_parties hp, igs_pe_hz_parties ihp,
277: igs_or_status os
278: WHERE vers.course_cd=spa.course_cd
279: AND vers.version_number=spa.version_number
280: AND spa.cal_type = l_acad_cal_type

Line 309: SELECT spa.person_id FROM igs_en_stdnt_ps_att spa

305: --term. The inactive and intermit status records are fetched irrespective of
306: --the d.ates
307:
308: CURSOR c_persons_for_course (cp_course_cd igs_ps_ver.course_cd%TYPE,cp_course_ver igs_ps_ver.version_number%TYPE, cp_nslc_condition VARCHAR2, l_grd_type VARCHAR2) IS
309: SELECT spa.person_id FROM igs_en_stdnt_ps_att spa
310: WHERE course_cd=cp_course_cd
311: AND version_number=cp_course_ver
312: AND spa.cal_type = l_acad_cal_type
313: AND

Line 1490: FROM igs_en_stdnt_ps_att_all

1486:
1487: CURSOR c_program_data IS
1488: SELECT nominated_completion_yr ,
1489: nominated_completion_perd
1490: FROM igs_en_stdnt_ps_att_all
1491: WHERE person_id = p_student_data.student_id
1492: AND cal_type = p_acad_cal_type
1493: AND course_attempt_status IN ('COMPLETED', 'ENROLLED', 'INACTIVE', 'INTERMIT')
1494: ORDER BY NVL(nominated_completion_yr,-1) desc, decode(nominated_completion_perd,'E',1,'S',2,'M',3,0) desc;

Line 1773: l_attendance_type igs_en_stdnt_ps_att_all.attendance_type%TYPE;

1769: l_grad_date DATE;
1770: l_W_temp_date DATE;
1771: l_lp_temp_date DATE;
1772: l_message_name VARCHAR2(100);
1773: l_attendance_type igs_en_stdnt_ps_att_all.attendance_type%TYPE;
1774: l_code VARCHAR2(3);
1775: l_career_profile VARCHAR2(1);
1776:
1777: CURSOR c_enr_status (l_status VARCHAR2) IS

Line 1887: igs_en_stdnt_ps_att pr,igs_ps_ver vers,igs_ca_load_to_teach_v lt

1883: -- smaddali modified for performance bug#4914052
1884: CURSOR c_outcome_dt(p_corresp_prg VARCHAR2) IS
1885: SELECT DISTINCT asv.outcome_dt
1886: FROM igs_as_su_atmpt_itm asv, igs_en_su_attempt asav,
1887: igs_en_stdnt_ps_att pr,igs_ps_ver vers,igs_ca_load_to_teach_v lt
1888: WHERE asv.person_id = asav.person_id
1889: AND asv.course_cd = asav.course_cd
1890: AND asv.uoo_id = asav.uoo_id
1891: AND asav.person_id = pr.person_id

Line 1924: FROM igs_en_stdnt_ps_att pr,

1920: pr.course_rqrmnts_complete_dt comp_dt,
1921: pr.version_number vers,
1922: pr.course_attempt_status status,
1923: pr.lapsed_dt lapsed_dt
1924: FROM igs_en_stdnt_ps_att pr,
1925: igs_ps_ver vers
1926: WHERE pr.person_id = p_student_id
1927: AND pr.cal_type = p_acad_cal_type
1928: AND

Line 2079: FROM igs_en_su_Attempt sua,igs_en_stdnt_ps_Att spa ,

2075: -- smaddali modified cursor form perf bug#4914052
2076: CURSOR cur_spa(cp_acad_cal_type igs_ca_inst.cal_type%TYPE,cp_load_cal_type igs_ca_inst.cal_type%TYPE,
2077: cp_load_cal_seq igs_ca_inst.sequence_number%TYPE) IS
2078: SELECT DISTINCT spa.course_cd, spa.version_number
2079: FROM igs_en_su_Attempt sua,igs_en_stdnt_ps_Att spa ,
2080: igs_ca_load_to_teach_v lod
2081: WHERE spa.person_id = p_student_id
2082: AND spa.cal_type = cp_acad_cal_type
2083: AND spa.person_id = sua.person_id

Line 2091: CURSOR c_other_sua ( cp_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE ) IS

2087: AND lod.load_cal_type = cp_load_cal_type
2088: AND lod.load_ci_sequence_number = cp_load_cal_seq;
2089:
2090: -- smaddali added these cursors for but#5440823
2091: CURSOR c_other_sua ( cp_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE ) IS
2092: SELECT sua.discontinued_dt
2093: FROM igs_en_su_attempt sua
2094: WHERE sua.person_id = p_student_id
2095: AND sua.course_cd = cp_course_cd

Line 2103: CURSOR c_disc_units(cp_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE) IS

2099: WHERE load_cal_type = p_load_cal_type AND load_ci_sequence_number = p_load_cal_seq
2100: );
2101: c_other_sua_rec c_other_sua%ROWTYPE;
2102:
2103: CURSOR c_disc_units(cp_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE) IS
2104: SELECT sua.discontinued_dt
2105: FROM igs_En_Su_Attempt sua
2106: WHERE person_id = p_student_id
2107: AND course_cd = cp_course_cd

Line 2679: igs_en_stdnt_ps_att pr,

2675: ut.uoo_id uoo_id,
2676: ut.override_enrolled_cp override_enrolled_cp,
2677: ut.override_eftsu override_eftsu
2678: FROM igs_en_su_attempt ut,
2679: igs_en_stdnt_ps_att pr,
2680: igs_ps_ver vers
2681: WHERE (ut.cal_type,ut.ci_sequence_number) IN
2682: (SELECT teach_cal_type,
2683: teach_ci_sequence_number

Line 2727: igs_en_stdnt_ps_att pr,

2723: ut.administrative_unit_status,
2724: ut.unit_attempt_status,
2725: ut.discontinued_dt
2726: FROM igs_en_su_attempt_h ut,
2727: igs_en_stdnt_ps_att pr,
2728: igs_ps_ver vers
2729: WHERE ut.cal_type = p_teach_cal_type
2730: AND ut.ci_sequence_number = p_teach_ci_sequence_number
2731: AND ut.person_id = p_student_id