APPS.CSR_SCHEDULER_PVT dependencies on JTF_TASKS_B

Line 90: FROM jtf_tasks_b t

86: , l.state
87: , l.postal_code
88: , fnd.territory_short_name country
89: , l.country country_code
90: FROM jtf_tasks_b t
91: , hz_locations l
92: , fnd_territories_vl fnd
93: WHERE t.task_id = p_task_id
94: AND l.location_id = csf_tasks_pub.get_task_location_id(t.task_id, t.address_id, t.location_id)

Line 381: FROM jtf_tasks_b

377: CURSOR c_task_info IS
378: SELECT planned_start_date
379: , planned_end_date
380: , source_object_id
381: FROM jtf_tasks_b
382: WHERE task_id = p_task_id;
383:
384: l_task_info c_task_info%ROWTYPE;
385:

Line 578: FROM jtf_tasks_b t

574: SELECT t.task_id
575: , t.planned_start_date
576: , t.planned_end_date
577: , t.source_object_id
578: FROM jtf_tasks_b t
579: WHERE t.task_id = p_task_id;
580:
581: l_task_info c_task_info%ROWTYPE;
582: BEGIN

Line 717: , jtf_tasks_b t

713: FROM csf_r_sched_requests
714: WHERE parent_request_id = p_request_id)
715: ) r
716: , csf_r_request_tasks rt
717: , jtf_tasks_b t
718: WHERE rt.sched_request_id = r.sched_request_id
719: AND NOT EXISTS ( SELECT 1
720: FROM csf_r_resource_results rr
721: WHERE rr.request_task_id = rt.request_task_id

Line 1077: FROM jtf_tasks_b t

1073: l_api_name CONSTANT VARCHAR2(30) := 'GET_QUALIFIED_RESOURCES';
1074:
1075: CURSOR c_task_info IS
1076: SELECT source_object_id
1077: FROM jtf_tasks_b t
1078: , TABLE( CAST ( p_task_id_tbl AS jtf_number_table ) ) tt
1079: WHERE t.task_id = tt.COLUMN_VALUE;
1080:
1081: l_res_qualifiers csf_resource_pub.resource_qualifier_tbl_type;

Line 1259: FROM jtf_tasks_b t

1255: SELECT t.task_id
1256: , ta.task_assignment_id
1257: , ah.access_hour_id
1258: , oc.object_capacity_id
1259: FROM jtf_tasks_b t
1260: , jtf_task_assignments ta
1261: , jtf_task_statuses_b ts
1262: , csf_access_hours_b ah
1263: , cac_sr_object_capacity oc