DBA Data[Home] [Help]

APPS.OKS_EXTWARPRGM_PVT dependencies on JTF_RS_SRP_GROUPS

Line 2373: FROM jtf_rs_srp_groups

2369:
2370: CURSOR l_salesgrp_csr (p_id NUMBER, p_start_date DATE, p_end_date DATE)
2371: IS
2372: SELECT GROUP_ID
2373: FROM jtf_rs_srp_groups
2374: WHERE salesrep_id = p_id
2375: AND org_id = okc_context.get_okc_org_id
2376: AND p_start_date BETWEEN start_date AND end_date
2377: AND p_end_date BETWEEN start_date AND end_date;

Line 3900: FROM jtf_rs_srp_groups

3896:
3897: CURSOR l_salesgrp_csr (p_id NUMBER, p_start_date DATE, p_end_date DATE)
3898: IS
3899: SELECT GROUP_ID
3900: FROM jtf_rs_srp_groups
3901: WHERE salesrep_id = p_id
3902: AND org_id = okc_context.get_okc_org_id
3903: AND p_start_date BETWEEN start_date AND end_date
3904: AND p_end_date BETWEEN start_date AND end_date;