APPS.CSM_LOBS_EVENT_PKG dependencies on JTF_TASK_ASSIGNMENTS

Line 901: FROM jtf_task_assignments jta, jtf_tasks_b jt,

897: fndattdoc.entity_name, fndattdoc.pk1_value, fndattdoc.pk2_value,
898: fndattdoc.seq_num,asg.user_name,fnddoccat_tl.user_name,
899: fnddoc.usage_type,doctype.user_name,fnddoc.datatype_id,
900: fnddoc.document_id,fnddoc_tl.title
901: FROM jtf_task_assignments jta, jtf_tasks_b jt,
902: fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,
903: fnd_document_categories_tl fnddoccat_tl,
904: fnd_attached_documents fndattdoc,
905: -- fnd_lobs lobs,

Line 940: FROM jtf_task_assignments jta,

936: fndattdoc.entity_name, fndattdoc.pk1_value, fndattdoc.pk2_value,
937: fndattdoc.seq_num,asg.user_name,fnddoccat_tl.user_name,
938: fnddoc.usage_type,doctype.user_name,fnddoc.datatype_id,
939: fnddoc.document_id,fnddoc_tl.title
940: FROM jtf_task_assignments jta,
941: fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,
942: fnd_document_categories_tl fnddoccat_tl,
943: fnd_attached_documents fndattdoc,
944: -- fnd_lobs lobs,

Line 1271: jtf_task_assignments jta,

1267: CURSOR c_SRAtt ( b_task_assignment_id IN NUMBER,
1268: b_user_id IN NUMBER) IS
1269: SELECT acc.access_id, acc.user_id
1270: FROM csm_fnd_lobs_acc acc,
1271: jtf_task_assignments jta,
1272: jtf_tasks_b jt
1273: WHERE acc.user_id = b_user_id
1274: AND acc.entity_name = 'CS_INCIDENTS'
1275: AND jt.task_id = jta.task_id

Line 1284: jtf_task_assignments jta

1280: CURSOR l_TaskAtt_csr ( b_task_assignment_id IN NUMBER,
1281: b_user_id IN NUMBER) IS
1282: SELECT acc.access_id, acc.user_id
1283: FROM csm_fnd_lobs_acc acc,
1284: jtf_task_assignments jta
1285: WHERE acc.user_id = b_user_id
1286: AND acc.entity_name = 'JTF_TASKS_B'
1287: AND jta.task_assignment_id = b_task_assignment_id
1288: AND acc.pk1_value = to_char(jta.task_id);