APPS.ENG_VAL_TO_ID dependencies on ENG_LIFECYCLE_STATUSES

Line 611: and ((status_code in (select status_code from eng_lifecycle_statuses

607: if p_plm_or_erp ='PLM' then
608: SELECT status_code ,status_type into l_st_code,l_st_type
609: from eng_change_statuses_vl
610: where status_name = p_status_name
611: and ((status_code in (select status_code from eng_lifecycle_statuses
612: where entity_name='ENG_CHANGE_TYPE'
613: and entity_id1 = p_change_order_type_id)
614: AND status_type <> 0)
615: OR status_type =0);