DBA Data[Home] [Help]

APPS.BOMPASGR dependencies on BOM_DEPARTMENTS

Line 1964: bom_departments bd

1960: BEGIN
1961: select bdr.AVAILABLE_24_HOURS_FLAG, bd.location_id
1962: into dummy_24hours, dummy_loc
1963: from bom_department_resources bdr,
1964: bom_departments bd
1965: where bdr.resource_id = c2rec.RI
1966: and bdr.department_id = dummy_dept
1967: and bdr.department_id = bd.department_id;
1968:

Line 2455: from bom_departments

2451:
2452: BEGIN
2453: select department_id
2454: into dept_id
2455: from bom_departments
2456: where organization_id = org_id
2457: and department_code = dept_code;
2458: return(0);
2459: EXCEPTION