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_AS_GEN_003 dependencies on IGS_PS_STDNT_UNT_TRN

Line 252: FROM IGS_PS_STDNT_UNT_TRN sut,

248: -- anilk, 22-Apr-2003, Bug# 2829262
249: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE
250: ) IS
251: SELECT sut.transfer_course_cd
252: FROM IGS_PS_STDNT_UNT_TRN sut,
253: IGS_EN_SU_ATTEMPT sua
254: WHERE sut.person_id = cp_person_id AND
255: sua.person_id = sut.person_id AND
256: -- anilk, 22-Apr-2003, Bug# 2829262

Line 304: -- This will use IGS_PS_STDNT_UNT_TRN details created as a result of

300: p_grade := NULL;
301: -- Depending on the status of the IGS_PS_UNIT attempt, set the grade search criteria.
302: IF (p_unit_attempt_status = cst_duplicate) THEN
303: -- Locate the original IGS_PS_UNIT attempt from which the grade was sourced.
304: -- This will use IGS_PS_STDNT_UNT_TRN details created as a result of
305: -- a IGS_PS_COURSE transfer
306: OPEN c_sua(
307: p_person_id,
308: p_unit_cd,

Line 528: FROM IGS_PS_STDNT_UNT_TRN sut,

524:
525: -- smaddali modified cursor for bug#4666657
526: CURSOR c_sua (cp_course_cd igs_en_su_attempt_all.course_Cd%TYPE ) IS
527: SELECT sut.transfer_course_cd , sua.unit_attempt_status
528: FROM IGS_PS_STDNT_UNT_TRN sut,
529: IGS_EN_SU_ATTEMPT sua
530: WHERE sut.person_id = p_person_id AND
531: sua.person_id = sut.person_id AND
532: -- anilk, 22-Apr-2003, Bug# 2829262

Line 579: -- This will use IGS_PS_STDNT_UNT_TRN details created as a result of

575: p_origin_course_cd := NULL;
576: -- Depending on the status of the IGS_PS_UNIT attempt, set the grade search criteria.
577: IF (p_unit_attempt_status = cst_duplicate) THEN
578: -- Locate the original IGS_PS_UNIT attempt from which the grade was sourced.
579: -- This will use IGS_PS_STDNT_UNT_TRN details created as a result of
580: -- a IGS_PS_COURSE transfer
581: -- smaddali modified logic for bug#4666657, to loop thru chain transfers
582: l_course_cd := p_course_cd;
583: LOOP

Line 1643: FROM IGS_PS_STDNT_UNT_TRN sut,

1639: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
1640: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE
1641: ) IS
1642: SELECT sut.transfer_course_cd
1643: FROM IGS_PS_STDNT_UNT_TRN sut,
1644: IGS_EN_SU_ATTEMPT sua
1645: WHERE sut.person_id = cp_person_id AND
1646: sua.person_id = sut.person_id AND
1647: sut.uoo_id = cp_uoo_id AND

Line 1693: -- This will use IGS_PS_STDNT_UNT_TRN details created as a result of

1689: p_grade := NULL;
1690: -- Depending on the status of the IGS_PS_UNIT attempt, set the grade search criteria.
1691: IF (p_unit_attempt_status = cst_duplicate) THEN
1692: -- Locate the original IGS_PS_UNIT attempt from which the grade was sourced.
1693: -- This will use IGS_PS_STDNT_UNT_TRN details created as a result of
1694: -- a IGS_PS_COURSE transfer
1695: OPEN c_sua(
1696: p_person_id,
1697: p_unit_cd,

Line 1836: FROM IGS_PS_STDNT_UNT_TRN sut,

1832: cp_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
1833: cp_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE
1834: ) IS
1835: SELECT sut.transfer_course_cd
1836: FROM IGS_PS_STDNT_UNT_TRN sut,
1837: IGS_EN_SU_ATTEMPT sua
1838: WHERE sut.person_id = cp_person_id AND
1839: sua.person_id = sut.person_id AND
1840: sut.uoo_id = cp_uoo_id AND

Line 1887: -- This will use IGS_PS_STDNT_UNT_TRN details created as a result of

1883: p_grade := NULL;
1884: -- Depending on the status of the IGS_PS_UNIT attempt, set the grade search criteria.
1885: IF (p_unit_attempt_status = cst_duplicate) THEN
1886: -- Locate the original IGS_PS_UNIT attempt from which the grade was sourced.
1887: -- This will use IGS_PS_STDNT_UNT_TRN details created as a result of
1888: -- a IGS_PS_COURSE transfer
1889: OPEN c_sua(
1890: p_person_id,
1891: p_unit_cd,