DBA Data[Home] [Help]

APPS.CSM_LOBS_EVENT_PKG dependencies on CSM_TASKS_ACC

Line 100: csm_tasks_acc acc, asg_user asg,

96: FROM fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,
97: fnd_document_categories_tl fnddoccat_tl,
98: fnd_attached_documents fndattdoc,
99: -- fnd_lobs lobs,
100: csm_tasks_acc acc, asg_user asg,
101: FND_DOCUMENT_DATATYPES doctype
102: WHERE fndattdoc.document_id = fnddoc_tl.document_id
103: AND fnddoc_tl.language = asg.language
104: AND fnddoc_tl.document_id = fnddoc.document_id

Line 521: csm_tasks_acc acc, asg_user asg,

517: FROM fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,
518: fnd_document_categories_tl fnddoccat_tl,
519: fnd_attached_documents fndattdoc,
520: -- fnd_lobs lobs,
521: csm_tasks_acc acc, asg_user asg,
522: FND_DOCUMENT_DATATYPES doctype
523: WHERE fndattdoc.document_id = fnddoc_tl.document_id
524: AND fnddoc_tl.language = asg.language
525: AND fnddoc_tl.document_id = fnddoc.document_id

Line 945: csm_tasks_acc acc,asg_user asg,

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,
945: csm_tasks_acc acc,asg_user asg,
946: FND_DOCUMENT_DATATYPES doctype
947: WHERE jta.task_assignment_id = b_task_assignment_id
948: AND acc.task_id = jta.task_id
949: AND fndattdoc.document_id = fnddoc_tl.document_id

Line 1523: csm_tasks_acc acc,

1519: FROM fnd_documents_tl fnddoc_tl,
1520: fnd_documents fnddoc,
1521: fnd_document_categories_tl fnddoccat_tl,
1522: fnd_attached_documents fndattdoc,
1523: csm_tasks_acc acc,
1524: asg_user asg,
1525: FND_DOCUMENT_DATATYPES doctype
1526: WHERE fndattdoc.document_id = fnddoc_tl.document_id
1527: AND fnddoc_tl.language = asg.language