DBA Data[Home] [Help]

APPS.CSF_TASKS_PUB dependencies on CSF_CT_TASK_ASSIGNMENTS

Line 827: , csf_ct_task_assignments ta

823: , ts.assigned_flag
824: , tt.schedule_flag tt_schedule_flag
825: , ta.resource_name
826: FROM jtf_tasks_b t
827: , csf_ct_task_assignments ta
828: , jtf_task_statuses_vl ts
829: , jtf_task_types_b tt
830: WHERE t.ROWID = CHARTOROWID (p_row_id)
831: AND ts.task_status_id = t.task_status_id

Line 1274: FROM csf_ct_task_assignments ta

1270: -- Cursor to get the Task Assignments to be cancelled
1271: CURSOR c_cancel_task_assignments IS
1272: SELECT ta.task_assignment_id
1273: , ta.object_version_number
1274: FROM csf_ct_task_assignments ta
1275: , jtf_task_statuses_b ts
1276: WHERE ta.task_id = p_task_id
1277: AND ts.task_status_id = ta.assignment_status_id
1278: AND ( NVL (ts.working_flag, 'N') = 'Y'