APPS.IGS_EN_GEN_001 dependencies on IGS_PS_UNIT_VER

Line 6: repeatable indicator in the igs_ps_unit_ver table

2: /* $Header: IGSEN01B.pls 120.1 2005/08/17 22:56:05 appldev ship $ */
3: /*
4: who when what
5: rvivekan 9-sep-2003 PSS integration build#3052433. modified behavior of
6: repeatable indicator in the igs_ps_unit_ver table
7: jbegum 25-Jun-2003 BUG#2930935
8: Modified local functions ENRP_CLC_SCA_PASS_CP
9: npalanis 8-may-2002 Bug - 2362467
10: The application id passed to function Check_HRMS_Installed

Line 176: -- repeatable_ind in the igs_ps_unit_ver table

172: --jbegum 25-jun-2003 Bug#2930935.Modified the cursor c_sua_uv
173: --kkillams 24-04-2003 Modified the c_sua_uv cursor and passing uoo_id to the
174: -- IGS_AS_GEN_003.assp_get_sua_outcome function w.r.t. bug number 2829262
175: --rvivekan 9-sep-2003 PSP integration build#3052433. modified behavior of
176: -- repeatable_ind in the igs_ps_unit_ver table
177:
178: -------------------------------------------------------------------------------------------
179: DECLARE
180: cst_completed CONSTANT VARCHAR2(10) := 'COMPLETED';

Line 207: IGS_PS_UNIT_VER uv,

203: NVL(cps.achievable_credit_points,uv.achievable_credit_points) achievable_credit_points,
204: NVL(cps.enrolled_credit_points,uv.enrolled_credit_points) enrolled_credit_points,
205: sua.uoo_id
206: FROM IGS_EN_SU_ATTEMPT sua,
207: IGS_PS_UNIT_VER uv,
208: IGS_PS_USEC_CPS cps,
209: IGS_CA_INST ci
210: WHERE sua.person_id = p_person_id AND
211: sua.course_cd = p_course_cd AND