APPS.IGS_PS_VAL_POSU dependencies on IGS_PS_UNIT_VER_ALL

Line 36: igs_ps_unit_ver_all a,

32:
33: CURSOR cur_multiple_section IS
34: SELECT 'X'
35: FROM igs_ps_pat_study_unt psu,
36: igs_ps_unit_ver_all a,
37: igs_ps_unit_stat b
38: WHERE
39: psu.course_cd = p_course_cd AND
40: psu.version_number = p_version_number AND

Line 290: p_unit_cd IN IGS_PS_UNIT_VER_ALL.unit_cd%TYPE ,

286: END crsp_val_posu_uoo;
287: --
288: -- Validate a least one version of the IGS_PS_UNIT is active.
289: FUNCTION crsp_val_uv_active(
290: p_unit_cd IN IGS_PS_UNIT_VER_ALL.unit_cd%TYPE ,
291: p_message_name OUT NOCOPY VARCHAR2 )
292: RETURN BOOLEAN AS
293: -- who when What
294: --sarakshi 23-dec-2002 Bug#2689625,removed the exception section