APPS.BOM_OPRESOURCE_PVT dependencies on BOM_DEPARTMENTS

Line 81: bom_departments bd,

77: br.AUTOCHARGE_TYPE),
78: nvl(br.AUTOCHARGE_TYPE, 2)) default_autocharge,
79: br.standard_rate_flag
80: from bom_resources br,
81: bom_departments bd,
82: bom_operation_sequences bos
83: where br.resource_id = P_ResourceId
84: and bos.operation_sequence_id = P_OpSeqId
85: and bd.department_id = bos.department_id;

Line 358: bom_departments bd,

354: cursor l_DeptRes_csr(P_ResourceId number, P_OpSeqId number) is
355: select bdr.AVAILABLE_24_HOURS_FLAG,
356: bd.location_id
357: from bom_department_resources bdr,
358: bom_departments bd,
359: bom_operation_sequences bos
360: where bdr.resource_id = P_ResourceId
361: and bos.operation_sequence_id = P_OpSeqId
362: and bdr.department_id = bos.department_id

Line 447: from bom_departments bd,

443: select 1 dummy
444: from dual
445: where not exists(
446: select 'no dept loc'
447: from bom_departments bd,
448: bom_operation_sequences bos
449: where bos.operation_sequence_id = P_OpSeqId
450: and bd.department_id = bos.department_id
451: and bd.location_id is not null);