APPS.IGS_PS_VAL_POSU dependencies on IGS_PS_UNIT_STAT

Line 37: igs_ps_unit_stat b

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
41: psu.cal_type = p_cal_type AND

Line 302: IGS_PS_UNIT_STAT ust

298: v_dummy VARCHAR2(1);
299: CURSOR c_chk_uv IS
300: SELECT 'X'
301: FROM IGS_PS_UNIT_VER uv,
302: IGS_PS_UNIT_STAT ust
303: WHERE uv.unit_cd = p_unit_cd AND
304: uv.unit_status = ust.unit_status AND
305: ust.s_unit_status = 'ACTIVE';
306: BEGIN