APPS.ENG_NEW_ITEM_REQ_UTIL dependencies on ENG_LIFECYCLE_STATUSES

Line 113: FROM eng_change_statuses_vl a, eng_lifecycle_statuses b

109:
110: CURSOR c_first_status (cp_change_mgmt_type_id IN eng_change_order_types_tl.change_order_type_id%TYPE)
111: IS
112: SELECT a.status_name INTO stat_name
113: FROM eng_change_statuses_vl a, eng_lifecycle_statuses b
114: WHERE a.status_code = b.status_code
115: AND b.entity_name='ENG_CHANGE_TYPE'
116: AND b.entity_id1 = cp_change_mgmt_type_id
117: ORDER BY b.sequence_number;