DBA Data[Home] [Help]

APPS.CSM_TASK_ASSIGNMENT_EVENT_PKG dependencies on CSM_DEBRIEF_HEADERS_ACC

Line 165: FROM csm_debrief_headers_acc acc

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
166: WHERE acc.debrief_header_id = dh.debrief_header_id
167: AND acc.user_id = p_user_id);
168:
169: BEGIN

Line 1248: FROM csm_debrief_headers_acc acc,

1244: CURSOR l_debrief_header_csr(p_task_assg_id jtf_task_assignments.task_assignment_id%TYPE,
1245: p_user_id fnd_user.user_id%TYPE)
1246: IS
1247: SELECT hdr.debrief_header_id
1248: FROM csm_debrief_headers_acc acc,
1249: csf_debrief_headers hdr
1250: WHERE hdr.task_assignment_id = p_task_assg_id
1251: AND acc.debrief_header_id = hdr.debrief_header_id
1252: AND acc.user_id = p_user_id