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 456: csm_tasks_acc acc, asg_user asg,

452: FROM fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,
453: fnd_document_categories_tl fnddoccat_tl,
454: fnd_attached_documents fndattdoc,
455: -- fnd_lobs lobs,
456: csm_tasks_acc acc, asg_user asg,
457: FND_DOCUMENT_DATATYPES doctype
458: WHERE fndattdoc.document_id = fnddoc_tl.document_id
459: AND fnddoc_tl.language = asg.language
460: AND fnddoc_tl.document_id = fnddoc.document_id

Line 880: csm_tasks_acc acc,asg_user asg,

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,
880: csm_tasks_acc acc,asg_user asg,
881: FND_DOCUMENT_DATATYPES doctype
882: WHERE jta.task_assignment_id = b_task_assignment_id
883: AND acc.task_id = jta.task_id
884: AND fndattdoc.document_id = fnddoc_tl.document_id

Line 1458: csm_tasks_acc acc,

1454: FROM fnd_documents_tl fnddoc_tl,
1455: fnd_documents fnddoc,
1456: fnd_document_categories_tl fnddoccat_tl,
1457: fnd_attached_documents fndattdoc,
1458: csm_tasks_acc acc,
1459: asg_user asg,
1460: FND_DOCUMENT_DATATYPES doctype
1461: WHERE fndattdoc.document_id = fnddoc_tl.document_id
1462: AND fnddoc_tl.language = asg.language