DBA Data[Home] [Help]

APPS.CSL_DEBRIEF_PKG dependencies on JTF_TASK_ASSIGNMENTS

Line 524: FROM csf_debrief_headers dh, jtf_task_assignments tas,

520: ( b_debrief_header_id CSF_DEBRIEF_HEADERS.DEBRIEF_HEADER_ID%TYPE
521: ) IS
522: SELECT tst.rejected_flag, tst.on_hold_flag, tst.cancelled_flag,
523: tst.closed_flag, tst.completed_flag
524: FROM csf_debrief_headers dh, jtf_task_assignments tas,
525: jtf_task_statuses_b tst
526: WHERE dh.task_assignment_id = tas.task_assignment_id
527: AND tas.assignment_status_id = tst.task_status_id
528: AND dh.debrief_header_id = b_debrief_header_id;

Line 573: , jtf_task_assignments jta

569: )
570: IS
571: SELECT source_object_type_code
572: FROM jtf_tasks_b jtb
573: , jtf_task_assignments jta
574: , csf_debrief_headers dbh
575: WHERE jtb.task_id = jta.task_id
576: AND jta.task_assignment_id = dbh.task_assignment_id
577: AND dbh.debrief_header_id = b_debrief_header_id;