APPS.ENG_IMPL_ITEM_CHANGES_PKG dependencies on ENG_REVISED_ITEMS

Line 416: FROM ENG_REVISED_ITEMS

412:
413: CURSOR C (c_change_line_id IN NUMBER)
414: IS
415: SELECT change_id
416: FROM ENG_REVISED_ITEMS
417: WHERE revised_item_sequence_id = c_change_line_id ;
418:
419:
420:

Line 1131: FROM eng_revised_items

1127: CURSOR getChangeLines (c_change_id NUMBER
1128: ,c_change_line_id NUMBER)
1129: IS
1130: SELECT revised_item_sequence_id
1131: FROM eng_revised_items
1132: WHERE change_id = c_change_id
1133: AND ( revised_item_sequence_id = c_change_line_id
1134: OR c_change_line_id IS NULL )
1135: AND implementation_date IS NULL

Line 5967: from eng_revised_items

5963: -- if new revision is created for this revised Item
5964: --
5965: select new_item_revision_id, current_item_revision_id
5966: into l_new_revision_id, l_old_revision_id
5967: from eng_revised_items
5968: where revised_item_sequence_id = p_change_line_id;
5969:
5970: EXCEPTION WHEN others THEN
5971: null;