2320:
2321: CURSOR l_salesgrp_csr (p_id NUMBER, p_start_date DATE, p_end_date DATE)
2322: IS
2323: SELECT GROUP_ID
2324: FROM jtf_rs_srp_groups
2325: WHERE salesrep_id = p_id
2326: AND org_id = okc_context.get_okc_org_id
2327: AND p_start_date BETWEEN start_date AND end_date
2328: AND p_end_date BETWEEN start_date AND end_date;
3825:
3826: CURSOR l_salesgrp_csr (p_id NUMBER, p_start_date DATE, p_end_date DATE)
3827: IS
3828: SELECT GROUP_ID
3829: FROM jtf_rs_srp_groups
3830: WHERE salesrep_id = p_id
3831: AND org_id = okc_context.get_okc_org_id
3832: AND p_start_date BETWEEN start_date AND end_date
3833: AND p_end_date BETWEEN start_date AND end_date;