DBA Data[Home] [Help]

APPS.CSM_DEBRIEF_HEADER_EVENT_PKG dependencies on JTF_TASK_ASSIGNMENTS

Line 34: jtf_task_assignments jta,

30: CURSOR l_csm_debrfHdInsInit_csr (p_debrief_header_id csf_debrief_headers.debrief_header_id%TYPE)
31: IS
32: SELECT dhdr.task_assignment_id, jtrs.user_id, jta.resource_id
33: FROM csf_debrief_headers dhdr,
34: jtf_task_assignments jta,
35: jtf_rs_resource_extns jtrs
36: WHERE dhdr.debrief_header_id = p_debrief_header_id
37: AND jta.task_assignment_id = dhdr.task_assignment_id
38: AND jtrs.resource_id (+)= jta.resource_id