APPS.CSF_RESOURCE_PUB dependencies on JTF_TASKS_B

Line 160: FROM jtf_tasks_b tb

156: , ib.contract_service_id
157: , TB.PLANNED_START_DATE
158: , ib.system_id
159: , ib.cust_pref_lang_code
160: FROM jtf_tasks_b tb
161: , cs_incidents_all_b ib
162: , cs_incidents_all_tl it
163: , hz_locations lo
164: , hz_parties pa

Line 917: FROM jtf_tasks_b t, hz_locations l

913: l_distance NUMBER;
914:
915: CURSOR c_task_geometry IS
916: SELECT l.geometry
917: FROM jtf_tasks_b t, hz_locations l
918: WHERE t.task_id = p_task_id
919: AND l.location_id = csf_tasks_pub.get_task_location_id(t.task_id, t.address_id, t.location_id);
920:
921: CURSOR c_sorted_resources IS

Line 1300: FROM csf_required_skills_b,jtf_tasks_b t

1296: -- Cursor to determine if the Task has any required skills
1297: -- and returns the has_skill_id
1298: CURSOR c_task_skills IS
1299: SELECT has_skill_id
1300: FROM csf_required_skills_b,jtf_tasks_b t
1301: WHERE t.task_id = p_task_id
1302: AND has_skill_type = 'TASK'
1303: AND has_skill_id = nvl(t.parent_task_id, t.task_id)
1304: AND NVL(disabled_flag, 'N') <> 'Y'

Line 1310: from jtf_tasks_b t, cs_incidents_all i, cs_incident_types_vl iv

1306:
1307: --Introduced by lokumar for bug#7340932
1308: CURSOR c_business_process IS
1309: select iv.business_process_id
1310: from jtf_tasks_b t, cs_incidents_all i, cs_incident_types_vl iv
1311: where t.task_id = p_task_id
1312: and t.source_object_id = i.incident_id
1313: and i.incident_type_id = iv.incident_type_id;
1314:

Line 1903: FROM jtf_tasks_b t

1899: , planned_start_date
1900: , planned_end_date
1901: , planned_effort
1902: , planned_effort_uom
1903: FROM jtf_tasks_b t
1904: WHERE t.task_id = p_task_id;
1905: l_task_info c_task_info%ROWTYPE;
1906: --
1907: CURSOR c_resource_info IS