DBA Data[Home] [Help]

APPS.PER_CHECKLIST_EVENTS dependencies on PER_TASKS_IN_CHECKLIST

Line 288: per_tasks_in_checklist ctsk,

284: ,ctsk.action_url
285: ,ckl.event_reason_id
286: ,ckl.business_group_id
287: from
288: per_tasks_in_checklist ctsk,
289: per_checklists ckl
290: where ckl.event_reason_id = pl_ler_event
291: and ctsk.checklist_id = ckl.checklist_id
292: order by ckl.checklist_id,ctsk.eligibility_object_id;

Line 303: per_tasks_in_checklist tic,

299: ,p_task_in_checklist_id number) is
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

Line 1181: FROM per_tasks_in_checklist

1177: ,information17
1178: ,information18
1179: ,information19
1180: ,information20
1181: FROM per_tasks_in_checklist
1182: WHERE checklist_id = cp_checklist_id;
1183: --
1184: lr_tasks c_tasks%ROWTYPE;
1185: --