APPS.IGS_PS_VALIDATE_LGCY_PKG dependencies on IGS_PS_SH_USEC_OCCURS_V

Line 1819: l_shd_instructor_id IGS_PS_SH_USEC_OCCURS_V.instructor_id%TYPE:= '1';

1815: l_shd_start_time VARCHAR2(50):='1';
1816: l_shd_end_time VARCHAR2(50):='1';
1817: l_shd_building_code VARCHAR2(10):='1';
1818: l_shd_room_code VARCHAR2(10):='1';
1819: l_shd_instructor_id IGS_PS_SH_USEC_OCCURS_V.instructor_id%TYPE:= '1';
1820: lv_usec_occur_id IGS_PS_USEC_OCCURS.unit_section_occurrence_id%TYPE:= 1;
1821: CURSOR c_insv_unit_sec_occur_id(l_unit_occur_id IGS_PS_USEC_OCCURS.unit_section_occurrence_id%TYPE) IS
1822: SELECT instructor_id from IGS_PS_SH_USEC_OCCURS
1823: WHERE unit_section_occurrence_id =l_unit_occur_id;