DBA Data[Home] [Help]

APPS.CSF_DEBRIEF_PVT dependencies on JTF_TASKS_VL

Line 192: from jtf_tasks_vl jtv,

188: l_task_status_id NUMBER := null;
189:
190: cursor c_source_object_type_code (p_task_assignment_id number) is
191: select jtv.source_object_type_code
192: from jtf_tasks_vl jtv,
193: jtf_task_assignments_v jta
194: where jta.task_assignment_id = p_task_assignment_id
195: and jta.task_id = jtv.task_id;
196:

Line 2984: FROM JTF_TASKS_VL

2980: ) IS
2981: l_version number;
2982: cursor c_version is
2983: SELECT OBJECT_VERSION_NUMBER
2984: FROM JTF_TASKS_VL
2985: WHERE TASK_ID = p_task_id;
2986: BEGIN
2987: OPEN C_VERSION;
2988: FETCH C_VERSION INTO l_version;