2842:
2843: -- Bug 2875120 3/27/03
2844: CURSOR /*+ ordered */ get_pay_element IS
2845: SELECT pay_element_type_id 2846: FROM cn_quota_pay_elements p, 2847: cn_rs_salesreps s
2848: WHERE p.quota_id = p_quota_id
2849: AND p_date between p.start_date and p.end_date
2850: AND s.salesrep_id = p_salesrep_id