DBA Data[Home] [Help]

APPS.PER_ABS_SHADOW_BOOKING_PKG dependencies on JTF_TASKS_VL

Line 180: FROM jtf_tasks_vl

176:
177: CURSOR c_bkg_id (cp_abs_id IN NUMBER) IS
178: SELECT task_type_id
179: ,object_version_number
180: FROM jtf_tasks_vl
181: WHERE source_object_type_code = 'ABSENCE'
182: AND source_object_id = cp_abs_id;
183:
184: BEGIN

Line 590: ' FROM jtf_tasks_vl T'||

586: ',T.task_name'||
587: ',TA.booking_start_date'||
588: ',TA.booking_end_date'||
589: ',TA.free_busy_type'||
590: ' FROM jtf_tasks_vl T'||
591: ',jtf_task_assignments TA'||
592: ' WHERE T.entity = "BOOKING"'||
593: ' AND T.task_id = TA.task_id'||
594: ' AND T.source_object_type_code = "ABSENCE"'||