DBA Data[Home] [Help]

APPS.JTF_RS_INTEGRATION_PUB dependencies on JTF_RS_SRP_GROUPS

Line 21: FROM jtf_rs_srp_groups

17: l_date := TRUNC(NVL(p_date, SYSDATE));
18:
19: SELECT group_id
20: INTO l_group_id
21: FROM jtf_rs_srp_groups
22: WHERE salesrep_id = p_salesrep_id
23: AND nvl(org_id,-99) = nvl(p_org_id,-99)
24: AND l_date BETWEEN start_date AND end_date;
25: