APPS.CSM_LOBS_EVENT_PKG dependencies on JTF_TASK_ASSIGNMENTS

Line 836: FROM jtf_task_assignments jta, jtf_tasks_b jt,

832: fndattdoc.entity_name, fndattdoc.pk1_value, fndattdoc.pk2_value,
833: fndattdoc.seq_num,asg.user_name,fnddoccat_tl.user_name,
834: fnddoc.usage_type,doctype.user_name,fnddoc.datatype_id,
835: fnddoc.document_id,fnddoc_tl.title
836: FROM jtf_task_assignments jta, jtf_tasks_b jt,
837: fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,
838: fnd_document_categories_tl fnddoccat_tl,
839: fnd_attached_documents fndattdoc,
840: -- fnd_lobs lobs,

Line 875: FROM jtf_task_assignments jta,

871: fndattdoc.entity_name, fndattdoc.pk1_value, fndattdoc.pk2_value,
872: fndattdoc.seq_num,asg.user_name,fnddoccat_tl.user_name,
873: fnddoc.usage_type,doctype.user_name,fnddoc.datatype_id,
874: fnddoc.document_id,fnddoc_tl.title
875: FROM jtf_task_assignments jta,
876: fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,
877: fnd_document_categories_tl fnddoccat_tl,
878: fnd_attached_documents fndattdoc,
879: -- fnd_lobs lobs,

Line 1206: jtf_task_assignments jta,

1202: CURSOR c_SRAtt ( b_task_assignment_id IN NUMBER,
1203: b_user_id IN NUMBER) IS
1204: SELECT acc.access_id, acc.user_id
1205: FROM csm_fnd_lobs_acc acc,
1206: jtf_task_assignments jta,
1207: jtf_tasks_b jt
1208: WHERE acc.user_id = b_user_id
1209: AND acc.entity_name = 'CS_INCIDENTS'
1210: AND jt.task_id = jta.task_id

Line 1219: jtf_task_assignments jta

1215: CURSOR l_TaskAtt_csr ( b_task_assignment_id IN NUMBER,
1216: b_user_id IN NUMBER) IS
1217: SELECT acc.access_id, acc.user_id
1218: FROM csm_fnd_lobs_acc acc,
1219: jtf_task_assignments jta
1220: WHERE acc.user_id = b_user_id
1221: AND acc.entity_name = 'JTF_TASKS_B'
1222: AND jta.task_assignment_id = b_task_assignment_id
1223: AND acc.pk1_value = to_char(jta.task_id);