APPS.PER_CHECKLIST_EVENTS dependencies on PER_TASKS_IN_CHECKLIST

Line 316: per_tasks_in_checklist ctsk,

312: ,ctsk.action_url
313: ,ckl.event_reason_id
314: ,ckl.business_group_id
315: from
316: per_tasks_in_checklist ctsk,
317: per_checklists ckl
318: where ckl.event_reason_id = pl_ler_event
319: and ctsk.checklist_id = ckl.checklist_id
320: order by ckl.checklist_id,ctsk.eligibility_object_id;

Line 331: per_tasks_in_checklist tic,

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

Line 1284: FROM per_tasks_in_checklist

1280: ,information17
1281: ,information18
1282: ,information19
1283: ,information20
1284: FROM per_tasks_in_checklist
1285: WHERE checklist_id = cp_checklist_id;
1286: --
1287: lr_tasks c_tasks%ROWTYPE;
1288: --

Line 1433: l_ame_attribute_identifier per_tasks_in_checklist.ame_attribute_identifier%type;

1429: END get_supervisor_id ;
1430: ---
1431: FUNCTION get_ame_attribute_identifier (p_transaction_id IN VARCHAR2) RETURN VARCHAR2
1432: IS
1433: l_ame_attribute_identifier per_tasks_in_checklist.ame_attribute_identifier%type;
1434: BEGIN
1435: SELECT AME_ATTRIBUTE_IDENTIFIER INTO l_ame_attribute_identifier
1436: FROM PER_TASKS_IN_CHECKLIST
1437: WHERE task_in_checklist_id= substr(p_transaction_id,1,instr(p_transaction_id,'-')-1);

Line 1436: FROM PER_TASKS_IN_CHECKLIST

1432: IS
1433: l_ame_attribute_identifier per_tasks_in_checklist.ame_attribute_identifier%type;
1434: BEGIN
1435: SELECT AME_ATTRIBUTE_IDENTIFIER INTO l_ame_attribute_identifier
1436: FROM PER_TASKS_IN_CHECKLIST
1437: WHERE task_in_checklist_id= substr(p_transaction_id,1,instr(p_transaction_id,'-')-1);
1438:
1439: RETURN l_ame_attribute_identifier ;
1440: