70:
71: l_person_id per_people_f.person_id%type;
72:
73: cursor get_trainer_id is
74: select osr.trainer_id from ota_suppliable_resources osr
75: where
76: osr.resource_type ='T'
77: and osr.supplied_resource_id = p_supplied_resource_id;
78:
396: from ota_resource_bookings orb
397: where resource_booking_id = p_resource_booking_id;
398:
399: cursor get_trainer_id is
400: select osr.trainer_id from ota_suppliable_resources osr
401: where
402: osr.resource_type ='T'
403: and osr.supplied_resource_id = p_supplied_resource_id;
404:
707: from ota_resource_bookings orb
708: where resource_booking_id = p_resource_booking_id;
709:
710: cursor get_trainer_id (crs_sup_res_id number)is
711: select osr.trainer_id from ota_suppliable_resources osr
712: where
713: osr.resource_type ='T'
714: and osr.supplied_resource_id = crs_sup_res_id;
715: