2864:
2865: -- Bug 2875120 3/27/03
2866: CURSOR /*+ ordered */ get_pay_element IS
2867: SELECT pay_element_type_id 2868: FROM cn_quota_pay_elements p, 2869: cn_rs_salesreps s
2870: WHERE p.quota_id = p_quota_id
2871: AND p_date between p.start_date and p.end_date
2872: AND s.salesrep_id = p_salesrep_id