DBA Data[Home] [Help]

APPS.ENG_VALIDATE_ECO dependencies on ENG_CHANGE_STATUSES_VL

Line 2346: from eng_lifecycle_statuses els, eng_change_statuses_vl ecs

2342: CURSOR c_lifecycle_status(cp_change_id NUMBER,cp_status_code NUMBER) IS
2343: select els.status_code, els.workflow_status, els.change_wf_route_id,
2344: ecs.status_type orig_status_type, els.CHANGE_EDITABLE_FLAG ,
2345: ecs.status_name
2346: from eng_lifecycle_statuses els, eng_change_statuses_vl ecs
2347: where els.ENTITY_NAME = 'ENG_CHANGE'
2348: and els.ENTITY_ID1 = cp_change_id
2349: and els.STATUS_CODE = cp_STATUS_CODE
2350: and els.active_flag = 'Y'