eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSM_TASK_ASSIGNMENT_EVENT_PKG dependencies on CSF_DEBRIEF_HEADERS

Line 161: FROM csf_debrief_headers dh

157: -- cursor to get all debrief header id
158: CURSOR l_debrief_header_csr(p_task_assg_id jtf_task_assignments.task_assignment_id%TYPE)
159: IS
160: SELECT dh.debrief_header_id
161: FROM csf_debrief_headers dh
162: WHERE dh.task_assignment_id =p_task_assg_id
163: AND NOT EXISTS
164: (SELECT 1
165: FROM csm_debrief_headers_acc acc

Line 207: csf_debrief_headers dh

203: IS
204: SELECT dl.debrief_line_id,
205: dh.debrief_header_id
206: FROM csf_debrief_lines dl,
207: csf_debrief_headers dh
208: WHERE dh.task_assignment_id =p_task_assg_id
209: AND dl.debrief_header_id = dh.debrief_header_id
210: AND NOT EXISTS
211: (SELECT 1

Line 1249: csf_debrief_headers hdr

1245: p_user_id fnd_user.user_id%TYPE)
1246: IS
1247: SELECT hdr.debrief_header_id
1248: FROM csm_debrief_headers_acc acc,
1249: csf_debrief_headers hdr
1250: WHERE hdr.task_assignment_id = p_task_assg_id
1251: AND acc.debrief_header_id = hdr.debrief_header_id
1252: AND acc.user_id = p_user_id
1253: ;

Line 1294: csF_debrief_headers hdr,

1290: IS
1291: SELECT dl.debrief_line_id,
1292: dl.debrief_header_id
1293: FROM csm_debrief_lines_acc acc,
1294: csF_debrief_headers hdr,
1295: csf_debrief_lines dl
1296: WHERE hdr.task_assignment_id = p_task_assg_id
1297: AND hdr.DEBRIEF_HEADER_ID = dl.DEBRIEF_HEADER_ID
1298: AND acc.debrief_line_id = dl.debrief_line_id