declare
 cursor cur_cust_num is
        select account_number
        from hz_cust_accounts 
        where cust_account_id in
        (select customer_id from gta_custmain 
        where gta_number=:gta_custmain.gta_number);  
	
	cursor cur_eng_mod is           
     select segment1 
		 from   mtl_system_items_b msi
		       ,gta_model gta
		       ,gta_custmain gtm
		 where gta.gta_number=gtm.gta_number
		 and msi.inventory_item_id = gta.engine_model_id
		 and msi.organization_id= gtm.org_id
		 and gta.gta_number=:gta_custmain.gta_number;
        
        
begin
	      open cur_cust_num ;
        fetch cur_cust_num into :gta_custmain.customer_number;
        close cur_cust_num; 
	      
	      open cur_eng_mod ;
        fetch cur_eng_mod into :gta_model.engine_model;        
        close cur_eng_mod; 

end;