3520: BEGIN
3521:
3522: SELECT type_name
3523: INTO l_change_type_code
3524: FROM eng_change_order_types_vl
3525: WHERE change_order_type_id = p_change_type_id
3526: AND change_mgmt_type_code = 'CHANGE_ORDER'
3527: AND type_classification='HEADER';
3528:
5144: ,hz_parties hp
5145: ,pa_projects_all ppa
5146: ,pa_proj_elements ppe
5147: ,hr_all_organization_units_vl haou
5148: ,eng_change_order_types_vl ecot
5149: WHERE
5150: eec.change_id = p_change_id AND
5151: eec.change_order_type_id =ecot.change_order_type_id AND
5152: mp.organization_id = eec.organization_id AND