DBA Data[Home] [Help]

APPS.OKS_EXTWARPRGM_PVT dependencies on JTF_RS_SRP_GROUPS

Line 2324: FROM jtf_rs_srp_groups

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;

Line 3829: FROM jtf_rs_srp_groups

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;