DBA Data[Home] [Help]

APPS.BOM_DELETE_ENTITY dependencies on BOM_DEPARTMENTS

Line 229: from bom_departments

225: operation_seq_num = oper_seq_num and
226: -- effectivity_date = effective_date and -- Changed for bug 2647027
227: trunc(effectivity_date) = trunc(effective_date) and -- Changed back for bug 3738241
228: department_id = (select department_id
229: from bom_departments
230: where department_code = dept_code and
231: organization_id = org_id);
232: BEGIN
233: FOR c_operseq IN operseq LOOP

Line 246: FROM bom_departments

242: RETURN VARCHAR2
243: IS
244: CURSOR dept is
245: select department_code
246: FROM bom_departments
247: where department_code = dept_code and
248: organization_id = org_id;
249: BEGIN
250: FOR c_dept IN dept LOOP