APPS.CSM_LOBS_EVENT_PKG dependencies on CSM_DEBRIEF_HEADERS_ACC

Line 133: csm_debrief_headers_acc acc, asg_user asg,

129: FROM fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,
130: fnd_document_categories_tl fnddoccat_tl,
131: fnd_attached_documents fndattdoc,
132: -- fnd_lobs lobs,
133: csm_debrief_headers_acc acc, asg_user asg,
134: FND_DOCUMENT_DATATYPES doctype
135: WHERE fndattdoc.document_id = fnddoc_tl.document_id
136: AND fnddoc_tl.language = asg.language
137: AND fnddoc_tl.document_id = fnddoc.document_id

Line 550: csm_debrief_headers_acc acc, asg_user asg,

546: FROM fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,
547: fnd_document_categories_tl fnddoccat_tl,
548: fnd_attached_documents fndattdoc,
549: -- fnd_lobs lobs,
550: csm_debrief_headers_acc acc, asg_user asg,
551: FND_DOCUMENT_DATATYPES doctype
552: WHERE fndattdoc.document_id = fnddoc_tl.document_id
553: AND fnddoc_tl.language = asg.language
554: AND fnddoc_tl.document_id = fnddoc.document_id

Line 869: csm_debrief_headers_acc acc,asg_user asg,

865: FROM csf_debrief_headers dbfhdr, fnd_attached_documents fndatt,
866: fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,
867: -- fnd_lobs lobs,
868: fnd_document_categories_tl fnddoccat_tl,
869: csm_debrief_headers_acc acc,asg_user asg,
870: FND_DOCUMENT_DATATYPES doctype
871: WHERE dbfhdr.task_assignment_id = b_task_assignment_id
872: AND acc.debrief_header_id = dbfhdr.debrief_header_id
873: AND acc.user_id = b_user_id

Line 1558: csm_debrief_headers_acc acc, asg_user asg,

1554: fnddoc.document_id,fnddoc_tl.title
1555: FROM fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,
1556: fnd_document_categories_tl fnddoccat_tl,
1557: fnd_attached_documents fndattdoc,
1558: csm_debrief_headers_acc acc, asg_user asg,
1559: FND_DOCUMENT_DATATYPES doctype
1560: WHERE fndattdoc.document_id = fnddoc_tl.document_id
1561: AND fnddoc_tl.language = asg.language
1562: AND fnddoc_tl.document_id = fnddoc.document_id