APPS.PER_CHECKLIST_EVENTS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 74

        SELECT 'Y'
        FROM   wf_local_roles
        WHERE  name = p_role_name;

Line: 150

    select
      TEXT_VALUE,RESPONDER
    from
     wf_notifications wfn,
     wf_notification_attributes wfna
    where
      wfn.notification_id=wfna.notification_id and context like cur_p_context and responder is not null and name ='RESULT';

Line: 203

    SELECT 'X'
    FROM per_ben_identified_events
    WHERE person_id             = p_person_id
    AND   nvl(assignment_id,-1) = nvl(p_assignment_id,-1)
    AND   event_reason_id       = p_ler_id
    AND   effective_date        = p_effective_date;

Line: 227

	insert into per_ben_identified_events(
             ben_identified_event_id,
	     event_reason_id,
	     person_id,
	     assignment_id,
	     status,
	     effective_date,
	     object_version_number)
	values(
	     per_ben_identified_events_s.nextval,
	     p_ler_id,
	     p_person_id,
	     p_assignment_id,
	     'Pending',
	     p_effective_date,
	     1);

Line: 271

    select
      ctsk.eligibility_object_id
     ,ckl.checklist_id
     ,ckl.name                 checklist_name
     ,ckl.description          checklist_description
     ,ckl.checklist_category
     ,ctsk.checklist_task_name
     ,ctsk.description         checklist_task_description
     ,ctsk.task_in_checklist_id
     ,ctsk.target_duration
     ,ctsk.target_duration_uom
     ,ctsk.mandatory_flag
     ,ctsk.ame_attribute_identifier
     ,ctsk.action_url
     ,ckl.event_reason_id
     ,ckl.business_group_id
    from
      per_tasks_in_checklist  ctsk,
      per_checklists          ckl
    where ckl.event_reason_id     = pl_ler_event
      and ctsk.checklist_id       = ckl.checklist_id
    order by ckl.checklist_id,ctsk.eligibility_object_id;

Line: 300

    select
      'Exists'
    from
      per_tasks_in_checklist   tic,
      per_allocated_checklists pac,
      per_allocated_tasks      pat
    where
      tic.task_in_checklist_id = p_task_in_checklist_id
      and pac.person_id        = p_person_id
      and tic.checklist_id     = pac.checklist_id
      and tic.checklist_task_name          = pat.task_name
      and pac.allocated_checklist_id     = pat.allocated_checklist_id;

Line: 316

    select allocated_checklist_id
    FROM per_allocated_checklists
    WHERE person_id     = p_person_id
    AND   nvl(assignment_id,-1) = nvl(p_assignment_id,-1)
    AND   checklist_id  = p_checklist_id;

Line: 549

              hr_utility.set_location('after insert',70);

Line: 632

      SELECT person_id ,
             assignment_id ,
             effective_date,
             event_reason_id
	FROM per_ben_identified_events
	WHERE status = 'Pending'
	FOR UPDATE OF status;

Line: 686

      UPDATE per_ben_identified_events
      SET status = 'Processed'
      WHERE CURRENT OF pending_events;

Line: 694

       delete from per_ben_identified_events
       where status = 'Processed';

Line: 723

      SELECT person_id ,
             assignment_id ,
             effective_date,
             event_reason_id
	FROM per_ben_identified_events
	WHERE status = 'Pending'
	AND   person_id = p_person_id
	FOR UPDATE OF status;

Line: 768

      UPDATE per_ben_identified_events
      SET status = 'Processed'
      WHERE CURRENT OF pending_events;

Line: 818

      select FULL_NAME
      from per_all_people_f
      where person_id = p_person_id
      and trunc(sysdate) between effective_start_date and effective_end_date;

Line: 933

          update PER_ALLOCATED_TASKS
          set status = 'COM'
          where ALLOCATED_TASK_ID =  l_alloc_id;

Line: 986

        update PER_ALLOCATED_TASKS
        set status = 'REJ'
        where ALLOCATED_TASK_ID =  l_alloc_id;

Line: 1132

      SELECT checklist_task_name
            ,description
            ,task_sequence
            ,mandatory_flag
            ,target_duration
            ,target_duration_uom
            ,action_url
            ,attribute_category
            ,attribute1
            ,attribute2
            ,attribute3
            ,attribute4
            ,attribute5
            ,attribute6
            ,attribute7
            ,attribute8
            ,attribute9
            ,attribute10
            ,attribute11
            ,attribute12
            ,attribute13
            ,attribute14
            ,attribute15
            ,attribute16
            ,attribute17
            ,attribute18
            ,attribute19
            ,attribute20
            ,information_category
            ,information1
            ,information2
            ,information3
            ,information4
            ,information5
            ,information6
            ,information7
            ,information8
            ,information9
            ,information10
            ,information11
            ,information12
            ,information13
            ,information14
            ,information15
            ,information16
            ,information17
            ,information18
            ,information19
            ,information20
      FROM per_tasks_in_checklist
      WHERE checklist_id = cp_checklist_id;

Line: 1204

          SELECT ADD_MONTHS(SYSDATE,lr_tasks.target_duration)
          INTO l_target_end_date FROM DUAL;