DBA Data[Home] [Help]

APPS.PER_CHECKLIST_EVENTS dependencies on PER_ALLOCATED_CHECKLISTS

Line 304: per_allocated_checklists pac,

300: select
301: 'Exists'
302: from
303: per_tasks_in_checklist tic,
304: per_allocated_checklists pac,
305: per_allocated_tasks pat
306: where
307: tic.task_in_checklist_id = p_task_in_checklist_id
308: and pac.person_id = p_person_id

Line 317: FROM per_allocated_checklists

313: cursor alloc_ckl_exists (p_person_id number
314: ,p_assignment_id number
315: ,p_checklist_id number) is
316: select allocated_checklist_id
317: FROM per_allocated_checklists
318: WHERE person_id = p_person_id
319: AND nvl(assignment_id,-1) = nvl(p_assignment_id,-1)
320: AND checklist_id = p_checklist_id;
321: