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_SPA_TERMS_API dependencies on IGS_EN_STDNT_PS_ATT

Line 125: select course_cd, cal_type from igs_en_stdnt_ps_att where person_id = p_person_id and key_program ='Y';

121: and ca1.start_dt < ca2.start_dt order by ca1.start_dt desc;
122:
123: -- Key program as in student program attempt and its academic calendar
124: CURSOR c_key_from_spa IS
125: select course_cd, cal_type from igs_en_stdnt_ps_att where person_id = p_person_id and key_program ='Y';
126:
127: -- Check if the academic calendar for the key determined is same as that of passed in term.
128: CURSOR c_key_in_same_acad(cp_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE) IS
129: SELECT 'x'

Line 216: FROM igs_en_stdnt_ps_att

212: attendance_type,
213: fee_cat,
214: coo_id,
215: IGS_PR_CLASS_STD_ID
216: FROM igs_en_stdnt_ps_att
217: WHERE person_id = p_person_id
218: AND course_cd = p_program_cd;
219:
220: l_program_cd IGS_PS_VER.COURSE_CD%TYPE;

Line 1552: FROM igs_en_stdnt_ps_att

1548:
1549: -- ## get the SPA values for the passed in program attempt
1550: CURSOR c_spa IS
1551: SELECT fee_cat
1552: FROM igs_en_stdnt_ps_att
1553: WHERE person_id = p_person_id
1554: AND course_cd = p_program_cd;
1555:
1556: l_fee_cat igs_en_spa_terms.fee_cat%TYPE;

Line 1630: FROM igs_en_stdnt_ps_att

1626:
1627: -- ## get the SPA values for the passed in program attempt
1628: CURSOR c_spa IS
1629: SELECT IGS_PR_CLASS_STD_ID
1630: FROM igs_en_stdnt_ps_att
1631: WHERE person_id = p_person_id
1632: AND course_cd = p_program_cd;
1633:
1634: l_class_standing igs_en_spa_terms.class_standing_id%TYPE;

Line 1708: FROM igs_en_stdnt_ps_att

1704:
1705: -- ## get the SPA values for the passed in program attempt
1706: CURSOR c_spa IS
1707: SELECT coo_id
1708: FROM igs_en_stdnt_ps_att
1709: WHERE person_id = p_person_id
1710: AND course_cd = p_program_cd;
1711:
1712: l_coo_id igs_en_spa_terms.coo_id%TYPE;

Line 1786: FROM igs_en_stdnt_ps_att

1782:
1783: -- ## get the SPA values for the passed in program attempt
1784: CURSOR c_spa IS
1785: SELECT attendance_type
1786: FROM igs_en_stdnt_ps_att
1787: WHERE person_id = p_person_id
1788: AND course_cd = p_program_cd;
1789:
1790: l_attendance_type igs_en_spa_terms.attendance_type%TYPE;

Line 1864: FROM igs_en_stdnt_ps_att

1860:
1861: -- ## get the SPA values for the passed in program attempt
1862: CURSOR c_spa IS
1863: SELECT attendance_mode
1864: FROM igs_en_stdnt_ps_att
1865: WHERE person_id = p_person_id
1866: AND course_cd = p_program_cd;
1867:
1868: l_attendance_mode igs_en_spa_terms.attendance_mode%TYPE;

Line 1942: FROM igs_en_stdnt_ps_att

1938:
1939: -- ## get the SPA values for the passed in program attempt
1940: CURSOR c_spa IS
1941: SELECT location_cd
1942: FROM igs_en_stdnt_ps_att
1943: WHERE person_id = p_person_id
1944: AND course_cd = p_program_cd;
1945:
1946: l_location_cd igs_en_spa_terms.location_cd%TYPE;

Line 2020: FROM igs_en_stdnt_ps_att

2016:
2017: -- ## get the SPA values for the passed in program attempt
2018: CURSOR c_spa IS
2019: SELECT version_number
2020: FROM igs_en_stdnt_ps_att
2021: WHERE person_id = p_person_id
2022: AND course_cd = p_program_cd;
2023:
2024: l_program_version igs_en_spa_terms.program_version%TYPE;

Line 2249: igs_en_stdnt_ps_att spa

2245: -- cursor to retrieve course_type for given program and person
2246: CURSOR cur_c2 IS
2247: SELECT ps.course_type
2248: FROM igs_ps_ver ps,
2249: igs_en_stdnt_ps_att spa
2250: WHERE
2251: spa.course_cd = p_program_cd AND
2252: spa.person_id = p_person_id AND
2253: spa.course_cd = ps.course_cd AND

Line 2298: FROM igs_en_stdnt_ps_att

2294: -- cursor to check whether given program for person exists in
2295: -- program attempt table
2296: CURSOR cur_c4 IS
2297: SELECT primary_program_type
2298: FROM igs_en_stdnt_ps_att
2299: WHERE
2300: person_id = p_person_id AND
2301: course_cd = p_program_cd;
2302:

Line 2304: l_primary_prg IGS_EN_STDNT_PS_ATT.PRIMARY_PROGRAM_TYPE%TYPE;

2300: person_id = p_person_id AND
2301: course_cd = p_program_cd;
2302:
2303:
2304: l_primary_prg IGS_EN_STDNT_PS_ATT.PRIMARY_PROGRAM_TYPE%TYPE;
2305: l_profile VARCHAR2(1);
2306: l_program_type IGS_PS_VER.COURSE_TYPE%TYPE;
2307: l_check VARCHAR2(1);
2308: l_program_cd IGS_EN_STDNT_PS_ATT.COURSE_CD%TYPE;

Line 2308: l_program_cd IGS_EN_STDNT_PS_ATT.COURSE_CD%TYPE;

2304: l_primary_prg IGS_EN_STDNT_PS_ATT.PRIMARY_PROGRAM_TYPE%TYPE;
2305: l_profile VARCHAR2(1);
2306: l_program_type IGS_PS_VER.COURSE_TYPE%TYPE;
2307: l_check VARCHAR2(1);
2308: l_program_cd IGS_EN_STDNT_PS_ATT.COURSE_CD%TYPE;
2309: l_start_dt IGS_CA_INST.START_DT%TYPE;
2310:
2311: BEGIN
2312:

Line 2675: FROM igs_en_stdnt_ps_att

2671:
2672: -- ## get the SPA values for the passed in program attempt
2673: CURSOR c_spa IS
2674: SELECT cal_type
2675: FROM igs_en_stdnt_ps_att
2676: WHERE person_id = p_person_id
2677: AND course_cd = p_program_cd;
2678:
2679: l_acad_cal_type igs_en_spa_terms.acad_cal_type%TYPE;