APPS.CSM_DEBRIEF_EXPENSES_PKG dependencies on JTF_TASK_ASSIGNMENTS

Line 47: , jtf_task_assignments jta

43: )
44: is
45: select source_object_type_code
46: from jtf_tasks_b jtb
47: , jtf_task_assignments jta
48: where jtb.task_id = jta.task_id
49: and jta.task_assignment_id = b_task_assignment_id;
50:
51: r_deb_head c_deb_head%rowtype;

Line 61: FROM csf_debrief_headers dh, jtf_task_assignments tas,

57: ( p_debrief_header_id CSF_DEBRIEF_HEADERS.DEBRIEF_HEADER_ID%TYPE
58: ) IS
59: SELECT tst.rejected_flag, tst.on_hold_flag, tst.cancelled_flag,
60: tst.closed_flag, tst.completed_flag
61: FROM csf_debrief_headers dh, jtf_task_assignments tas,
62: jtf_task_statuses_b tst
63: WHERE dh.task_assignment_id = tas.task_assignment_id
64: AND tas.assignment_status_id = tst.task_status_id
65: AND dh.debrief_header_id = p_debrief_header_id;