DBA Data[Home] [Help]

APPS.EAM_WORKORDERS_JSP dependencies on BOM_DEPARTMENTS

Line 1347: from bom_departments

1343: BEGIN
1344: IF(p_owning_department IS NOT NULL) THEN
1345: select department_id
1346: into l_dept_id
1347: from bom_departments
1348: where organization_id = p_organization_id
1349: and department_code = p_owning_department;
1350: END IF;
1351: EXCEPTION WHEN OTHERS THEN

Line 2619: from bom_departments

2615:
2616: BEGIN
2617: select department_id
2618: into l_dept_id
2619: from bom_departments
2620: where organization_id = l_org_id
2621: and department_code = p_owning_department;
2622:
2623: EXCEPTION WHEN OTHERS THEN