DBA Data[Home] [Help]

APPS.CSM_TASK_ASSIGNMENT_EVENT_PKG dependencies on CSF_DEBRIEF_LINES

Line 206: FROM csf_debrief_lines dl,

202: CURSOR l_debrief_lines_csr(p_task_assg_id jtf_task_assignments.task_assignment_id%TYPE)
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

Line 1295: csf_debrief_lines dl

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
1299: AND acc.user_id = p_user_id