APPS.CSF_TASKS_PUB dependencies on CSF_CT_TASK_ASSIGNMENTS

Line 740: , csf_ct_task_assignments ta

736: , ts.assigned_flag
737: , tt.schedule_flag tt_schedule_flag
738: , ta.resource_name
739: FROM jtf_tasks_b t
740: , csf_ct_task_assignments ta
741: , jtf_task_statuses_vl ts
742: , jtf_task_types_b tt
743: WHERE t.ROWID = CHARTOROWID (p_row_id)
744: AND ts.task_status_id = t.task_status_id

Line 1168: FROM csf_ct_task_assignments ta

1164: -- Cursor to get the Task Assignments to be cancelled
1165: CURSOR c_cancel_task_assignments IS
1166: SELECT ta.task_assignment_id
1167: , ta.object_version_number
1168: FROM csf_ct_task_assignments ta
1169: , jtf_task_statuses_b ts
1170: WHERE ta.task_id = p_task_id
1171: AND ts.task_status_id = ta.assignment_status_id
1172: AND ( NVL (ts.working_flag, 'N') = 'Y'