APPS.EAM_SRAPPROVAL_PVT dependencies on BOM_DEPARTMENTS

Line 19: l_owning_department_code bom_departments.department_code%type;

15: l_incident_number cs_incidents_all_b.incident_number%type;
16: l_incident_id cs_incidents_all_b.incident_id%type;
17:
18: l_owning_department_id cs_incidents_all_b.owning_department_id%type;
19: l_owning_department_code bom_departments.department_code%type;
20: l_owning_department_role varchar2(80);
21: l_inventory_item_id cs_incidents_all_b.inventory_item_id%type;
22: l_maintenance_flag varchar2(1);
23: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%type;

Line 138: from bom_departments

134: l_owning_department_id := l_default_department_id;
135:
136: select department_code
137: into l_owning_department_code
138: from bom_departments
139: where department_id = l_owning_department_id
140: and organization_id = l_maint_organization_id;
141:
142: -- call service request update API to update the owning dept on Service Request

Line 177: from bom_departments

173: end if;
174: else
175: select department_code
176: into l_owning_department_code
177: from bom_departments
178: where department_id = l_owning_department_id
179: and organization_id = l_maint_organization_id;
180:
181: end if;

Line 292: l_owning_department_code bom_departments.department_code%type;

288: l_incident_number cs_incidents_all_b.incident_number%type;
289: l_incident_id cs_incidents_all_b.incident_id%type;
290:
291: l_owning_department_id cs_incidents_all_b.owning_department_id%type;
292: l_owning_department_code bom_departments.department_code%type;
293: l_owning_department_role varchar2(80);
294: l_inventory_item_id cs_incidents_all_b.inventory_item_id%type;
295: l_maintenance_flag varchar2(1);
296: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%type;

Line 387: from bom_departments

383: l_owning_department_id := l_default_department_id;
384:
385: select department_code
386: into l_owning_department_code
387: from bom_departments
388: where department_id = l_owning_department_id
389: and organization_id = l_maint_organization_id;
390:
391: -- call service request update API to update the owning dept on Service Request

Line 424: from bom_departments

420: end if;
421: else
422: select department_code
423: into l_owning_department_code
424: from bom_departments
425: where department_id = l_owning_department_id
426: and organization_id = l_maint_organization_id;
427: end if;
428: