APPS.IGS_EN_ELGBL_UNIT dependencies on IGS_PS_VER

Line 3402: igs_ps_ver pv

3398:
3399: CURSOR cur_org(p_person_id NUMBER , p_org_unit_cd VARCHAR2) IS
3400: SELECT 'X'
3401: FROM igs_en_stdnt_ps_att sca,
3402: igs_ps_ver pv
3403: WHERE sca.person_id = p_person_id AND
3404: sca.course_cd = pv.course_cd AND
3405: sca.version_number = pv.version_number AND
3406: pv.responsible_org_unit_cd = p_org_unit_cd;

Line 4332: IGS_PS_VER.course_cd%TYPE of the cursor,cur_intermission_details for the bug:2381603

4328: ) RETURN BOOLEAN AS
4329: /* HISTORY
4330: WHO WHEN WHAT
4331: ayedubat 07-JUN-2002 Changed the type of cursor parameter,cp_program_cd from NUMBER to
4332: IGS_PS_VER.course_cd%TYPE of the cursor,cur_intermission_details for the bug:2381603
4333: svenkata 26-JUN-2002 The IF condition for the Intermission records had a logical error . The same has been
4334: fixed .Bug # 2423604
4335: */
4336: --

Line 4363: cp_program_cd IGS_PS_VER.course_cd%TYPE

4359: -- Cursor to find Intermission Type and Start Date for a given Person and Program.
4360: --
4361: CURSOR cur_intermission_details (
4362: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
4363: cp_program_cd IGS_PS_VER.course_cd%TYPE
4364: ) IS
4365: SELECT sci.intermission_type,
4366: sci.start_dt,
4367: sci.approved

Line 4953: from igs_ps_type ct, igs_ps_ver cv

4949: AND OVERRIDE_IND = 'Y';
4950:
4951: CURSOR c_prog_award IS
4952: select NVL(AWARD_COURSE_IND,'N')
4953: from igs_ps_type ct, igs_ps_ver cv
4954: where cv.course_cd = p_course_Cd
4955: and cv.version_number = p_course_version
4956: and cv.course_type = ct.course_type;
4957: