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 1181: csf_debrief_headers hdr

1177: p_user_id fnd_user.user_id%TYPE)
1178: IS
1179: SELECT hdr.debrief_header_id
1180: FROM csm_debrief_headers_acc acc,
1181: csf_debrief_headers hdr
1182: WHERE hdr.task_assignment_id = p_task_assg_id
1183: AND acc.debrief_header_id = hdr.debrief_header_id
1184: AND acc.user_id = p_user_id
1185: ;

Line 1226: csF_debrief_headers hdr,

1222: IS
1223: SELECT dl.debrief_line_id,
1224: dl.debrief_header_id
1225: FROM csm_debrief_lines_acc acc,
1226: csF_debrief_headers hdr,
1227: csf_debrief_lines dl
1228: WHERE hdr.task_assignment_id = p_task_assg_id
1229: AND hdr.DEBRIEF_HEADER_ID = dl.DEBRIEF_HEADER_ID
1230: AND acc.debrief_line_id = dl.debrief_line_id