260: lookup_code
261: AND lookup_type = 'ENG_ECN_APPROVAL_STATUS'), /*approval status*/
262: (SELECT organization_code FROM mtl_parameters WHERE
263: organization_id=eec.organization_id),
264: (SELECT NAME FROM hr_all_organization_units WHERE
265: organization_id=eec.organization_id),
266: mev.full_name,
267: ecot.type_name,
268: (SELECT NAME FROM hr_all_organization_units WHERE
264: (SELECT NAME FROM hr_all_organization_units WHERE
265: organization_id=eec.organization_id),
266: mev.full_name,
267: ecot.type_name,
268: (SELECT NAME FROM hr_all_organization_units WHERE
269: organization_id=eec.responsible_organization_id),
270: (SELECT organization_code FROM mtl_parameters WHERE
271: organization_id=eec.responsible_organization_id),
272: eec.task_id,