APPS.IGS_PS_WF_EVENT_HOOK_PKG dependencies on IGS_PS_USEC_OCCURS

Line 65: FROM IGS_PS_USEC_OCCURS

61: start_time,
62: end_time,
63: building_code,
64: room_code
65: FROM IGS_PS_USEC_OCCURS
66: WHERE notify_status='TRIGGER'
67: AND unit_section_occurrence_id = p_unit_section_occurrence_id;
68: OPEN p_old_values FOR SELECT unit_section_occurrence_id,
69: Monday,

Line 92: FROM IGS_PS_USEC_OCCURS a,

88: p_instructors IN OUT NOCOPY IGS_PS_WF_EVENT_HOOK_PKG.InstructorDetails)
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:

Line 97: l_inst_notify_ind IGS_PS_USEC_OCCURS.inst_notify_ind%TYPE;

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;
98: l_instructor_id IGS_PS_USO_INSTRCTRS_V.instructor_id%TYPE;
99: BEGIN
100:
101: IF p_type='MOD' THEN