DBA Data[Home] [Help]

APPS.CSM_TASK_ASSIGNMENT_EVENT_PKG dependencies on CSM_DEBRIEF_LINES_ACC

Line 212: FROM csm_debrief_lines_acc acc

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
212: FROM csm_debrief_lines_acc acc
213: WHERE acc.debrief_line_id = dl.debrief_line_id
214: AND acc.user_id = p_user_id);
215:
216: BEGIN

Line 1225: FROM csm_debrief_lines_acc acc,

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,
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