DBA Data[Home] [Help]

APPS.CSM_DEBRIEF_EVENT_PKG dependencies on JTF_TASK_ASSIGNMENTS

Line 166: jtf_task_assignments jta,

162: NVL(NVL(issuing_inventory_org_id, receiving_inventory_org_id), csm_profile_pkg.get_organization_id(jtrs.user_id)) AS organization_id,
163: usage_type
164: FROM csf_debrief_lines dbl,
165: csf_debrief_headers dhdr,
166: jtf_task_assignments jta,
167: jtf_rs_resource_extns jtrs
168: WHERE dbl.debrief_line_id = p_debrief_line_id
169: AND dbl.debrief_header_id = dhdr.debrief_header_id
170: AND jta.task_assignment_id = dhdr.task_assignment_id

Line 384: jtf_task_assignments jta,

380: usage_type
381: FROM csf_debrief_lines dbl,
382: csf_debrief_headers dhdr,
383: csm_debrief_lines_acc acc,
384: jtf_task_assignments jta,
385: jtf_rs_resource_extns jtrs
386: WHERE dbl.debrief_line_id = p_debrief_line_id
387: AND dbl.debrief_header_id = dhdr.debrief_header_id
388: AND jta.task_assignment_id = dhdr.task_assignment_id