DBA Data[Home] [Help]

APPS.CSF_RESOURCE_PUB dependencies on CS_INCIDENTS_ALL

Line 142: , cs_incidents_all_b ib

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
146: WHERE tb.task_id = p_task_id

Line 143: , cs_incidents_all_tl it

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
146: WHERE tb.task_id = p_task_id
147: AND tb.source_object_type_code = 'SR'

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: