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 485: csm_debrief_headers_acc acc, asg_user asg,

481: FROM fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,
482: fnd_document_categories_tl fnddoccat_tl,
483: fnd_attached_documents fndattdoc,
484: -- fnd_lobs lobs,
485: csm_debrief_headers_acc acc, asg_user asg,
486: FND_DOCUMENT_DATATYPES doctype
487: WHERE fndattdoc.document_id = fnddoc_tl.document_id
488: AND fnddoc_tl.language = asg.language
489: AND fnddoc_tl.document_id = fnddoc.document_id

Line 804: csm_debrief_headers_acc acc,asg_user asg,

800: FROM csf_debrief_headers dbfhdr, fnd_attached_documents fndatt,
801: fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,
802: -- fnd_lobs lobs,
803: fnd_document_categories_tl fnddoccat_tl,
804: csm_debrief_headers_acc acc,asg_user asg,
805: FND_DOCUMENT_DATATYPES doctype
806: WHERE dbfhdr.task_assignment_id = b_task_assignment_id
807: AND acc.debrief_header_id = dbfhdr.debrief_header_id
808: AND acc.user_id = b_user_id

Line 1493: csm_debrief_headers_acc acc, asg_user asg,

1489: fnddoc.document_id,fnddoc_tl.title
1490: FROM fnd_documents_tl fnddoc_tl, fnd_documents fnddoc,
1491: fnd_document_categories_tl fnddoccat_tl,
1492: fnd_attached_documents fndattdoc,
1493: csm_debrief_headers_acc acc, asg_user asg,
1494: FND_DOCUMENT_DATATYPES doctype
1495: WHERE fndattdoc.document_id = fnddoc_tl.document_id
1496: AND fnddoc_tl.language = asg.language
1497: AND fnddoc_tl.document_id = fnddoc.document_id