APPS.ENG_IMPL_ITEM_CHANGES_PKG dependencies on ENG_REVISED_ITEMS

Line 415: FROM ENG_REVISED_ITEMS

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

Line 1122: FROM eng_revised_items

1118: CURSOR getChangeLines (c_change_id NUMBER
1119: ,c_change_line_id NUMBER)
1120: IS
1121: SELECT revised_item_sequence_id
1122: FROM eng_revised_items
1123: WHERE change_id = c_change_id
1124: AND ( revised_item_sequence_id = c_change_line_id
1125: OR c_change_line_id IS NULL )
1126: AND implementation_date IS NULL

Line 5929: from eng_revised_items

5925: -- if new revision is created for this revised Item
5926: --
5927: select new_item_revision_id, current_item_revision_id
5928: into l_new_revision_id, l_old_revision_id
5929: from eng_revised_items
5930: where revised_item_sequence_id = p_change_line_id;
5931:
5932: EXCEPTION WHEN others THEN
5933: null;