APPS.PER_CHECKLIST_EVENTS dependencies on PER_BEN_IDENTIFIED_EVENTS

Line 204: FROM per_ben_identified_events

200: l_proc varchar2(72) ;
201: --cursor event_exists(p_person_id number,p_assignment_id number,p_ler_id number, p_effective_date date) is
202: cursor event_exists is
203: SELECT 'X'
204: FROM per_ben_identified_events
205: WHERE person_id = p_person_id
206: AND nvl(assignment_id,-1) = nvl(p_assignment_id,-1)
207: AND event_reason_id = p_ler_id
208: AND effective_date = p_effective_date;

Line 227: insert into per_ben_identified_events(

223: if event_exists%notfound then
224: if g_debug then
225: hr_utility.set_location('Entering '||l_proc,20);
226: end if;
227: insert into per_ben_identified_events(
228: ben_identified_event_id,
229: event_reason_id,
230: person_id,
231: assignment_id,

Line 236: per_ben_identified_events_s.nextval,

232: status,
233: effective_date,
234: object_version_number)
235: values(
236: per_ben_identified_events_s.nextval,
237: p_ler_id,
238: p_person_id,
239: p_assignment_id,
240: 'Pending',

Line 636: FROM per_ben_identified_events

632: SELECT person_id ,
633: assignment_id ,
634: effective_date,
635: event_reason_id
636: FROM per_ben_identified_events
637: WHERE status = 'Pending'
638: FOR UPDATE OF status;
639: --
640: l_proc varchar2(72) ;

Line 686: UPDATE per_ben_identified_events

682: end if;
683: --
684: -- Update the status from PENDING to Processed
685: --
686: UPDATE per_ben_identified_events
687: SET status = 'Processed'
688: WHERE CURRENT OF pending_events;
689: end loop;
690: --

Line 694: delete from per_ben_identified_events

690: --
691: -- Purge records that are processed. Purges all records
692: --
693: if nvl(p_purge,'N') = 'Y' then
694: delete from per_ben_identified_events
695: where status = 'Processed';
696: end if;
697: --
698: commit;

Line 727: FROM per_ben_identified_events

723: SELECT person_id ,
724: assignment_id ,
725: effective_date,
726: event_reason_id
727: FROM per_ben_identified_events
728: WHERE status = 'Pending'
729: AND person_id = p_person_id
730: FOR UPDATE OF status;
731:

Line 768: UPDATE per_ben_identified_events

764: hr_utility.set_location('after process call',4);
765: --
766: -- Update the status from PENDING to Processed
767: --
768: UPDATE per_ben_identified_events
769: SET status = 'Processed'
770: WHERE CURRENT OF pending_events;
771: end loop;
772: