DBA Data[Home] [Help]

APPS.CSF_DEBRIEF_PVT dependencies on JTF_TASKS_VL

Line 179: from jtf_tasks_vl jtv,

175: l_task_status_id NUMBER := null;
176:
177: cursor c_source_object_type_code (p_task_assignment_id number) is
178: select jtv.source_object_type_code
179: from jtf_tasks_vl jtv,
180: jtf_task_assignments_v jta
181: where jta.task_assignment_id = p_task_assignment_id
182: and jta.task_id = jtv.task_id;
183:

Line 2916: FROM JTF_TASKS_VL

2912: ) IS
2913: l_version number;
2914: cursor c_version is
2915: SELECT OBJECT_VERSION_NUMBER
2916: FROM JTF_TASKS_VL
2917: WHERE TASK_ID = p_task_id;
2918: BEGIN
2919: OPEN C_VERSION;
2920: FETCH C_VERSION INTO l_version;