APPS.WIP_OPERATION_VALIDATE dependencies on BOM_DEPARTMENTS

Line 281: EXISTS IN BOM_DEPARTMENTS TABLE.

277:
278:
279: /*****************************************************************
280: CHECK THAT THE GIVEN P_DEPARTMENT_ID, P_ORGANIZATION_ID COMBINATION
281: EXISTS IN BOM_DEPARTMENTS TABLE.
282: *******************************************************************/
283: procedure val_dept(p_group_id in number,
284: p_wip_entity_id in number,
285: p_organization_id in number,

Line 303: from bom_departments

299: and p_sub_type = wip_job_details.wip_add
300: )
301: or ( department_id is not null
302: and not exists (select 1
303: from bom_departments
304: where department_id = wjdi.department_id
305: and organization_id = wjdi.organization_id)
306: )
307: );

Line 340: from bom_departments

336: and p_sub_type = wip_job_details.wip_add
337: )
338: or ( department_id is not null
339: and not exists (select 1
340: from bom_departments
341: where department_id = wjdi.department_id
342: and organization_id = wjdi.organization_id)
343: )
344: );