DBA Data[Home] [Help]

APPS.CSM_TASK_ASSIGNMENT_EVENT_PKG dependencies on FND_USER

Line 1245: p_user_id fnd_user.user_id%TYPE)

1241: l_return_status VARCHAR2(2000);
1242:
1243: -- cursor to get all debrief header id
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

Line 1289: p_user_id fnd_user.user_id%TYPE)

1285: l_return_status VARCHAR2(2000);
1286:
1287: -- cursor to get all debrief line id
1288: CURSOR l_debrief_lines_csr(p_task_assg_id jtf_task_assignments.task_assignment_id%TYPE,
1289: p_user_id fnd_user.user_id%TYPE)
1290: IS
1291: SELECT dl.debrief_line_id,
1292: dl.debrief_header_id
1293: FROM csm_debrief_lines_acc acc,