APPS.ENG_DEFAULT_REV_COMPONENT dependencies on ENG_REVISED_ITEMS

Line 132: FROM eng_revised_items

128: RETURN DATE
129: IS
130: CURSOR c_EffectiveDate IS
131: SELECT scheduled_date
132: FROM eng_revised_items
133: WHERE revised_item_sequence_id =
134: g_Rev_Comp_Unexp_Rec.revised_item_sequence_id;
135: BEGIN
136:

Line 317: FROM eng_revised_items

313: NVL(g_rev_component_rec.alternate_bom_code, 'NONE');
314:
315: CURSOR c_CheckBillInRevisedItem IS
316: SELECT bill_sequence_id
317: FROM eng_revised_items
318: WHERE revised_item_sequence_id =
319: g_rev_comp_unexp_rec.revised_item_sequence_id;
320:
321: l_bill_sequence_id NUMBER;

Line 332: -- If bill sequence id is not found in Eng_Revised_Items

328: END IF;
329: END LOOP;
330:
331: --
332: -- If bill sequence id is not found in Eng_Revised_Items
333: -- Only then go to the Bom Table to look for Bill_Sequence_Id
334: --
335: OPEN c_CheckForNew;
336: FETCH c_CheckForNew INTO l_bill_sequence_id;