APPS.PER_CHECKLIST_EVENTS dependencies on PER_ALLOCATED_CHECKLISTS

Line 47: FROM per_allocated_tasks pat, per_allocated_checklists pac

43: ,aname => 'ALLOC_TASKID'
44: ,ignore_notfound => false
45: );
46: SELECT pac.person_id INTO l_person_id
47: FROM per_allocated_tasks pat, per_allocated_checklists pac
48: WHERE allocated_task_id = l_allocated_task_id
49: AND pac.allocated_checklist_id = pat.allocated_checklist_id;
50:
51: l_transaction_id := l_taskin_cklid||'-'||l_person_id;

Line 332: per_allocated_checklists pac,

328: select
329: 'Exists'
330: from
331: per_tasks_in_checklist tic,
332: per_allocated_checklists pac,
333: per_allocated_tasks pat
334: where
335: tic.task_in_checklist_id = p_task_in_checklist_id
336: and pac.person_id = p_person_id

Line 345: FROM per_allocated_checklists

341: cursor alloc_ckl_exists (p_person_id number
342: ,p_assignment_id number
343: ,p_checklist_id number) is
344: select allocated_checklist_id
345: FROM per_allocated_checklists
346: WHERE person_id = p_person_id
347: AND nvl(assignment_id,-1) = nvl(p_assignment_id,-1)
348: AND checklist_id = p_checklist_id;
349: