APPS.IGS_PS_WF_EVENT_HOOK_PKG dependencies on IGS_PS_USO_INSTRCTRS_V

Line 93: IGS_PS_USO_INSTRCTRS_V b

89: IS
90: CURSOR c_notify IS SELECT a.inst_notify_ind,
91: b.instructor_id
92: FROM IGS_PS_USEC_OCCURS a,
93: IGS_PS_USO_INSTRCTRS_V b
94: WHERE a.unit_section_occurrence_id = p_unit_section_occurrence_id
95: AND a.unit_section_occurrence_id=b.unit_section_occurrence_id;
96:
97: l_inst_notify_ind IGS_PS_USEC_OCCURS.inst_notify_ind%TYPE;

Line 98: l_instructor_id IGS_PS_USO_INSTRCTRS_V.instructor_id%TYPE;

94: WHERE a.unit_section_occurrence_id = p_unit_section_occurrence_id
95: AND a.unit_section_occurrence_id=b.unit_section_occurrence_id;
96:
97: l_inst_notify_ind IGS_PS_USEC_OCCURS.inst_notify_ind%TYPE;
98: l_instructor_id IGS_PS_USO_INSTRCTRS_V.instructor_id%TYPE;
99: BEGIN
100:
101: IF p_type='MOD' THEN
102: IF p_students%ISOPEN THEN