APPS.BOM_UTIL dependencies on ENG_ENGINEERING_CHANGES

Line 498: eng_engineering_changes eec,

494: CURSOR c_get_change_notice(c_p_change_line_id NUMBER)
495: IS
496: SELECT eec.change_notice
497: FROM
498: eng_engineering_changes eec,
499: eng_revised_items eri--eng_change_lines ecl
500: WHERE eri.change_id/*cl.change_id*/ = eec.change_id
501: -- AND ecl.change_line_id = c_p_change_line_id;
502: AND eri.revised_item_sequence_id = c_p_change_line_id;

Line 503: l_change_notice eng_engineering_changes.change_notice%type;

499: eng_revised_items eri--eng_change_lines ecl
500: WHERE eri.change_id/*cl.change_id*/ = eec.change_id
501: -- AND ecl.change_line_id = c_p_change_line_id;
502: AND eri.revised_item_sequence_id = c_p_change_line_id;
503: l_change_notice eng_engineering_changes.change_notice%type;
504: BEGIN
505: OPEN c_get_change_notice(p_change_line_id);
506: FETCH c_get_change_notice INTO l_change_notice;
507: IF c_get_change_notice%FOUND THEN