APPS.CSF_RESOURCE_PUB dependencies on JTF_TASKS_B

Line 141: FROM jtf_tasks_b tb

137: , ib.inv_organization_id squal_num16
138: , ib.owner_group_id squal_num17
139: , ib.language_id squal_num30
140: , ib.contract_service_id
141: FROM jtf_tasks_b tb
142: , cs_incidents_all_b ib
143: , cs_incidents_all_tl it
144: , hz_locations lo
145: , hz_parties pa

Line 753: FROM jtf_tasks_b t, hz_locations l

749: l_distance NUMBER;
750:
751: CURSOR c_task_geometry IS
752: SELECT l.geometry
753: FROM jtf_tasks_b t, hz_locations l
754: WHERE t.task_id = p_task_id
755: AND l.location_id = csf_tasks_pub.get_task_location_id(t.task_id, t.address_id, t.location_id);
756:
757: CURSOR c_sorted_resources IS

Line 1119: FROM csf_required_skills_b,jtf_tasks_b t

1115: -- Cursor to determine if the Task has any required skills
1116: -- and returns the has_skill_id
1117: CURSOR c_task_skills IS
1118: SELECT has_skill_id
1119: FROM csf_required_skills_b,jtf_tasks_b t
1120: WHERE t.task_id = p_task_id
1121: AND has_skill_type = 'TASK'
1122: AND has_skill_id = nvl(t.parent_task_id, t.task_id)
1123: AND NVL(disabled_flag, 'N') <> 'Y'

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

1125:
1126: --Introduced by lokumar for bug#7340932
1127: CURSOR c_business_process IS
1128: select iv.business_process_id
1129: from jtf_tasks_b t, cs_incidents_all i, cs_incident_types_vl iv
1130: where t.task_id = p_task_id
1131: and t.source_object_id = i.incident_id
1132: and i.incident_type_id = iv.incident_type_id;
1133: