APPS.CSR_SCHEDULER_PVT dependencies on JTF_TASKS_B

Line 96: FROM jtf_tasks_b t

92: , l.postal_code
93: , fnd.territory_short_name country
94: , l.country country_code
95: , l.geometry_status_code
96: FROM jtf_tasks_b t
97: , hz_locations l
98: , fnd_territories_vl fnd
99: WHERE t.task_id = p_task_id
100: AND l.location_id = csf_tasks_pub.get_task_location_id(t.task_id, t.address_id, t.location_id)

Line 395: FROM jtf_tasks_b

391: k PLS_INTEGER;
392:
393: CURSOR c_task_info IS
394: SELECT planned_start_date, planned_end_date, source_object_id
395: FROM jtf_tasks_b
396: WHERE task_id = p_task_id;
397:
398: l_task_info c_task_info%ROWTYPE;
399:

Line 591: FROM jtf_tasks_b t

587: l_res_qualifiers csf_resource_pub.resource_qualifier_tbl_type;
588:
589: CURSOR c_task_info (p_task_id NUMBER) IS
590: SELECT t.task_id, t.planned_start_date, t.planned_end_date, t.source_object_id
591: FROM jtf_tasks_b t
592: WHERE t.task_id = p_task_id;
593:
594: l_task_info c_task_info%ROWTYPE;
595: BEGIN

Line 743: , jtf_tasks_b t

739: FROM csf_r_sched_requests
740: WHERE parent_request_id = p_request_id)
741: ) r
742: , csf_r_request_tasks rt
743: , jtf_tasks_b t
744: WHERE rt.sched_request_id = r.sched_request_id
745: AND NOT EXISTS ( SELECT 1
746: FROM csf_r_resource_results rr
747: WHERE rr.request_task_id = rt.request_task_id

Line 1152: FROM jtf_tasks_b t

1148: l_role VARCHAR2(30) := NULL;
1149:
1150: CURSOR c_task_info IS
1151: SELECT source_object_id
1152: FROM jtf_tasks_b t
1153: , TABLE( CAST ( p_task_id_tbl AS jtf_number_table ) ) tt
1154: WHERE t.task_id = tt.COLUMN_VALUE;
1155:
1156: l_res_qualifiers csf_resource_pub.resource_qualifier_tbl_type;

Line 1340: FROM jtf_tasks_b t

1336: SELECT t.task_id
1337: , ta.task_assignment_id
1338: , ah.access_hour_id
1339: , oc.object_capacity_id
1340: FROM jtf_tasks_b t
1341: , jtf_task_assignments ta
1342: , jtf_task_statuses_b ts
1343: , csf_access_hours_b ah
1344: , cac_sr_object_capacity oc