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

Line 301: IGS_EN_STDNT_PS_ATT sca

297: sua.discontinued_dt,
298: sca.version_number,
299: sua.uoo_id
300: FROM IGS_EN_SU_ATTEMPT sua,
301: IGS_EN_STDNT_PS_ATT sca
302: WHERE sua.person_id = p_person_id AND
303: sua.course_cd = p_course_cd AND
304: sca.person_id = sua.person_id AND
305: sca.course_cd = sua.course_cd AND

Line 315: cp_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE) IS

311: cst_discontin);
312: CURSOR c_cat_ci_cir_cs2 (
313: cp_sua_cal_type IGS_EN_SU_ATTEMPT.cal_type%TYPE,
314: cp_sua_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
315: cp_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE) IS
316: SELECT cir.sup_cal_type,
317: cir.sup_ci_sequence_number
318: FROM IGS_CA_TYPE cat,
319: IGS_CA_INST ci1,

Line 614: v_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;

610: RETURN NUMBER AS
611: gv_other_detail VARCHAR2(255);
612: BEGIN
613: DECLARE
614: v_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
615: v_time_elapsed NUMBER;
616: v_yrs_elapsed NUMBER;
617: CURSOR c_sca IS
618: SELECT sca.commencement_dt

Line 619: FROM IGS_EN_STDNT_PS_ATT sca

615: v_time_elapsed NUMBER;
616: v_yrs_elapsed NUMBER;
617: CURSOR c_sca IS
618: SELECT sca.commencement_dt
619: FROM IGS_EN_STDNT_PS_ATT sca
620: WHERE sca.person_id = p_person_id AND
621: sca.course_cd = p_course_cd;
622: BEGIN
623: --Routine to calculate the elapsed time taken by a student for a