39: --
40: CURSOR requestor_cursor IS
41: SELECT HE.full_name
42: FROM hr_employees HE,
43: po_distributions PD
44: WHERE PD.line_location_id = l_line_location_id
45: AND PD.deliver_to_person_id = HE.employee_id;
46:
47: BEGIN
92: BEGIN
93:
94: SELECT count(*)
95: INTO num_distributions
96: FROM po_distributions PD
97: WHERE PD.line_location_id = l_line_location_id;
98:
99: RETURN(num_distributions);
100: