DBA Data[Home] [Help]

APPS.ENG_VALIDATE_ECO dependencies on ENG_CHANGE_STATUSES_VL

Line 2343: from eng_lifecycle_statuses els, eng_change_statuses_vl ecs

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