APPS.ENGECOBO dependencies on ENG_CHANGE_ORDER_TYPES

Line 2020: FROM eng_change_order_types_v --11.5.10 Changes

2016: IF (eco_rec.change_order_type_id IS NOT NULL) THEN
2017:
2018: SELECT CHANGE_ORDER_TYPE
2019: INTO l_change_type_code
2020: FROM eng_change_order_types_v --11.5.10 Changes
2021: WHERE change_order_type_id = eco_rec.change_order_type_id;
2022:
2023: ELSE
2024:

Line 4050: l_change_mgmt_type Eng_change_order_types_tl.type_name%TYPE; --Bug 3544760

4046: -- Local Identifiers
4047: l_local_change_id NUMBER;
4048: -- Exposed Column Data
4049: l_change_type_code VARCHAR2(80);
4050: l_change_mgmt_type Eng_change_order_types_tl.type_name%TYPE; --Bug 3544760
4051: l_requestor_name VARCHAR2(30);
4052: l_assignee_name VARCHAR2(360);
4053: l_Task_Number VARCHAR2(25);
4054: l_Project_Number VARCHAR2(30);

Line 4071: l_default_assignee_type eng_change_order_types.default_assignee_type%TYPE;

4067: l_approval_status VARCHAR2(80);
4068: l_task_number1 VARCHAR2(100);
4069: l_party_id NUMBER;
4070: l_party_type VARCHAR2(30);
4071: l_default_assignee_type eng_change_order_types.default_assignee_type%TYPE;
4072: l_assignee_role_id NUMBER;
4073: l_status_name eng_change_statuses_tl.status_name%TYPE;
4074: l_department_name VARCHAR2(240);
4075: l_change_type_id NUMBER;

Line 4254: FROM eng_change_order_types_v ecotv

4250: INTO l_change_type_code
4251: , l_change_mgmt_type
4252: , l_default_assignee_type
4253: , l_assignee_role_id
4254: FROM eng_change_order_types_v ecotv
4255: , eng_change_mgmt_types_vl ecmtv
4256: WHERE ecotv.change_order_type_id = eco_rec.change_order_type_id
4257: AND ecotv.CHANGE_MGMT_TYPE_CODE = ecmtv.CHANGE_MGMT_TYPE_CODE;
4258: ELSE