DBA Data[Home] [Help]

APPS.PER_EVENTS_PKG dependencies on PER_ASSIGNMENTS

Line 129: from per_assignments_f

125: v_change_exists boolean;
126: --
127: cursor csr_assignment is
128: select 1
129: from per_assignments_f
130: where assignment_id = p_assignment_id
131: and effective_start_date = p_event_date;
132: --
133: begin

Line 170: from per_events event, per_assignments assignment

166: l_same_time boolean;
167: --
168: cursor csr_double_booking is
169: select event.time_start, nvl(event.time_end,'24:00')
170: from per_events event, per_assignments assignment
171: where (p_rowid is null or p_rowid <> event.rowid)
172: and assignment.person_id = p_person_id
173: and event.assignment_id = assignment.assignment_id
174: and event.event_or_interview = 'I'