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.CSL_CSF_DEBRIEF_LINE_ACC_PKG dependencies on CSF_DEBRIEF_HEADERS

Line 345: FROM CSF_DEBRIEF_HEADERS CDH, CSF_DEBRIEF_LINES CDL

341: )
342: IS
343: CURSOR c_debrief_line (b_task_assignment_id NUMBER) IS
344: SELECT CDL.debrief_line_id
345: FROM CSF_DEBRIEF_HEADERS CDH, CSF_DEBRIEF_LINES CDL
346: WHERE CDH.task_assignment_id = b_task_assignment_id
347: AND CDH.debrief_header_id = CDL.debrief_header_id;
348: r_debrief_line c_debrief_line%ROWTYPE;
349:

Line 472: FROM CSF_DEBRIEF_HEADERS CDH, CSF_DEBRIEF_LINES CDL

468: )
469: IS
470: CURSOR c_debrief_line (b_task_assignment_id NUMBER) IS
471: SELECT CDL.debrief_line_id
472: FROM CSF_DEBRIEF_HEADERS CDH, CSF_DEBRIEF_LINES CDL
473: WHERE CDH.task_assignment_id = b_task_assignment_id
474: AND CDH.debrief_header_id = CDL.debrief_header_id;
475: r_debrief_line c_debrief_line%ROWTYPE;
476:

Line 518: , csf_debrief_headers dbh

514: CURSOR c_resource ( b_debrief_line_id NUMBER)
515: IS
516: SELECT resource_id
517: FROM jtf_task_assignments jta
518: , csf_debrief_headers dbh
519: , csf_debrief_lines dbl
520: WHERE jta.task_assignment_id = dbh.task_assignment_id
521: AND dbh.debrief_header_id = dbl.debrief_header_id
522: AND dbl.debrief_line_id = b_debrief_line_id;