APPS.PER_CHECKLIST_EVENTS dependencies on PER_ALLOCATED_TASKS

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 333: per_allocated_tasks pat

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
337: and tic.checklist_id = pac.checklist_id

Line 970: l_PERFORMER_ORIG_SYS_ID PER_ALLOCATED_TASKS.PERFORMER_ORIG_SYS_ID%type;

966: l_alloc_id number;
967: l_proc varchar2(72);
968: -- bug 7560762
969: l_task_done_by wf_local_roles.name%type;
970: l_PERFORMER_ORIG_SYS_ID PER_ALLOCATED_TASKS.PERFORMER_ORIG_SYS_ID%type;
971:
972: cursor c_performer_orig_sys_id(p_task_done_by varchar2) is
973: SELECT ORIG_SYSTEM_ID
974: FROM wf_local_roles

Line 1012: update PER_ALLOCATED_TASKS

1008: close c_performer_orig_sys_id;
1009: hr_utility.set_location('l_PERFORMER_ORIG_SYS_ID '||l_PERFORMER_ORIG_SYS_ID,100);
1010: -- bug 7560762
1011: --
1012: update PER_ALLOCATED_TASKS
1013: set status = 'COM',
1014: performer_orig_sys_id = nvl(l_performer_orig_sys_id,performer_orig_sys_id) -- bug 7560762
1015: where ALLOCATED_TASK_ID = l_alloc_id;
1016: --

Line 1048: l_PERFORMER_ORIG_SYS_ID PER_ALLOCATED_TASKS.PERFORMER_ORIG_SYS_ID%type;

1044: l_alloc_id number;
1045: l_proc varchar2(72);
1046: -- bug 7560762
1047: l_task_done_by wf_local_roles.name%type;
1048: l_PERFORMER_ORIG_SYS_ID PER_ALLOCATED_TASKS.PERFORMER_ORIG_SYS_ID%type;
1049:
1050: cursor c_performer_orig_sys_id(p_task_done_by varchar2) is
1051: SELECT ORIG_SYSTEM_ID
1052: FROM wf_local_roles

Line 1088: update PER_ALLOCATED_TASKS

1084: fetch c_performer_orig_sys_id into l_PERFORMER_ORIG_SYS_ID;
1085: close c_performer_orig_sys_id;
1086: -- bug 7560762 ends
1087:
1088: update PER_ALLOCATED_TASKS
1089: set status = 'REJ',
1090: performer_orig_sys_id = nvl(l_performer_orig_sys_id,performer_orig_sys_id) -- bug 7560762
1091: where ALLOCATED_TASK_ID = l_alloc_id;
1092: --