APPS.EAM_DOWNTIME_PUB dependencies on BOM_DEPARTMENTS

Line 1096: (select department_id from bom_departments

1092: downtime_group_id is not null
1093: and simulation_set=p_simulation_set
1094: and ((p_department_id is not null and department_id=p_department_id)
1095: or (p_department_id is null and department_id in
1096: (select department_id from bom_departments
1097: where organization_id=p_org_id)))
1098: and ((p_resource_id is not null and resource_id=p_resource_id)
1099: or (p_resource_id is null));
1100:

Line 1108: (select department_id from bom_departments

1104: downtime_group_id is not null
1105: and simulation_set=p_simulation_set
1106: and ((p_department_id is not null and department_id=p_department_id)
1107: or (p_department_id is null and department_id in
1108: (select department_id from bom_departments
1109: where organization_id=p_org_id)))
1110: and ((p_resource_id is not null and resource_id=p_resource_id)
1111: or (p_resource_id is null));
1112:

Line 1330: (select department_id from bom_departments

1326: where
1327: downtime_group_id is not null
1328: and simulation_set=p_simulation_set
1329: and department_id in
1330: (select department_id from bom_departments
1331: where
1332: organization_id=p_org_id);
1333:
1334: delete from bom_resource_changes

Line 1339: (select department_id from bom_departments

1335: where
1336: downtime_group_id is not null
1337: and simulation_set=p_simulation_set
1338: and department_id in
1339: (select department_id from bom_departments
1340: where
1341: organization_id=p_org_id);
1342:
1343: