APPS.BOMPVALR dependencies on BOM_DEPARTMENTS

Line 2855: from bom_departments

2851: dummy VARCHAR2(20);
2852: BEGIN
2853: select 'x'
2854: into dummy
2855: from bom_departments
2856: where organization_id = org_id
2857: and department_id = dept_id
2858: and nvl(DISABLE_DATE, to_date(eff_date,'YYYY/MM/DD HH24:MI') +1) >
2859: to_date(eff_date,'YYYY/MM/DD HH24:MI');

Line 2967: from bom_departments bd

2963: from bom_op_resources_interface ori
2964: where operation_sequence_id = op_seq
2965: and autocharge_type in (3,4)
2966: and not exists (select 'no dept loc or res pur item'
2967: from bom_departments bd
2968: where bd.department_id = dept_id
2969: and bd.location_id is not null);
2970:
2971: if (cnt <> 0) then