APPS.CSM_LOBS_EVENT_PKG dependencies on CSM_INCIDENTS_ALL_ACC

Line 67: csm_incidents_all_acc acc, asg_user asg,

63: FROM fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,
64: fnd_document_categories_tl fnddoccat_tl,
65: fnd_attached_documents fndattdoc,
66: -- fnd_lobs lobs,
67: csm_incidents_all_acc acc, asg_user asg,
68: FND_DOCUMENT_DATATYPES doctype
69: WHERE fndattdoc.document_id = fnddoc_tl.document_id
70: AND fnddoc_tl.language = asg.language
71: AND asg.user_id=asg.owner_id

Line 427: csm_incidents_all_acc acc, asg_user asg,

423: FROM fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,
424: fnd_document_categories_tl fnddoccat_tl,
425: fnd_attached_documents fndattdoc,
426: -- fnd_lobs lobs,
427: csm_incidents_all_acc acc, asg_user asg,
428: FND_DOCUMENT_DATATYPES doctype
429: WHERE fndattdoc.document_id = fnddoc_tl.document_id
430: AND fnddoc_tl.language = asg.language
431: AND fnddoc_tl.document_id = fnddoc.document_id

Line 841: csm_incidents_all_acc acc,asg_user asg,

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,
841: csm_incidents_all_acc acc,asg_user asg,
842: FND_DOCUMENT_DATATYPES doctype
843: WHERE jta.task_assignment_id = b_task_assignment_id
844: AND jta.task_id = jt.task_id
845: AND jt.source_object_id = acc.incident_id

Line 1422: csm_incidents_all_acc acc,

1418: FROM fnd_documents_tl fnddoc_tl,
1419: fnd_documents fnddoc,
1420: fnd_document_categories_tl fnddoccat_tl,
1421: fnd_attached_documents fndattdoc,
1422: csm_incidents_all_acc acc,
1423: asg_user asg,
1424: FND_DOCUMENT_DATATYPES doctype
1425: WHERE fndattdoc.document_id = fnddoc_tl.document_id
1426: AND fnddoc_tl.language = asg.language