1173: l_return_status VARCHAR2(2000);
1174:
1175: -- cursor to get all debrief header id
1176: CURSOR l_debrief_header_csr(p_task_assg_id jtf_task_assignments.task_assignment_id%TYPE,
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
1217: l_return_status VARCHAR2(2000);
1218:
1219: -- cursor to get all debrief line id
1220: CURSOR l_debrief_lines_csr(p_task_assg_id jtf_task_assignments.task_assignment_id%TYPE,
1221: p_user_id fnd_user.user_id%TYPE)
1222: IS
1223: SELECT dl.debrief_line_id,
1224: dl.debrief_header_id
1225: FROM csm_debrief_lines_acc acc,