APPS.OKS_EXTWAR_UTIL_PVT dependencies on JTF_RS_SALESREPS

Line 37: cursor l_sname_csr (p_resid number) is select name from jtf_rs_salesreps where resource_id = p_resid;

33: l_user_id fnd_user.user_id%TYPE;
34: l_index Number;
35: i Number;
36: l_org_id Number;
37: cursor l_sname_csr (p_resid number) is select name from jtf_rs_salesreps where resource_id = p_resid;
38: l_sname Varchar2(240);
39:
40: Begin
41: okc_context.set_okc_org_context;

Line 3965: ,jtf_rs_salesreps srp

3961: /* Cursor l_salesgroup_csr(p_salesrep_id Number) Is
3962: SELECT DISTINCT grp.group_name, grp.group_id
3963: FROM jtf_rs_group_members mem
3964: ,jtf_rs_groups_vl grp
3965: ,jtf_rs_salesreps srp
3966: ,jtf_rs_group_usages usg
3967: ,jtf_rs_role_relations rrl
3968: WHERE srp.resource_id = mem.resource_id
3969: AND mem.group_id = grp.group_id

Line 4922: FROM jtf_rs_resource_extns re, jtf_rs_salesreps sr

4918: IS
4919: CURSOR l_get_source_csr (p_salesrep_id NUMBER, p_authorg_id NUMBER)
4920: IS
4921: SELECT source_id
4922: FROM jtf_rs_resource_extns re, jtf_rs_salesreps sr
4923: WHERE sr.resource_id = re.resource_id
4924: AND sr.salesrep_id = p_salesrep_id
4925: AND (sr.org_id = p_authorg_id OR p_authorg_id IS NULL);
4926:

Line 5609: FROM okc_contacts con1, jtf_rs_salesreps salesrep

5605: p_org_id IN NUMBER
5606: )
5607: IS
5608: SELECT con1.ID
5609: FROM okc_contacts con1, jtf_rs_salesreps salesrep
5610: WHERE con1.dnz_chr_id = p_contract_id
5611: AND jtot_object1_code = 'OKX_SALEPERS'
5612: AND con1.cpl_id = p_party_id
5613: AND TRUNC (SYSDATE) BETWEEN NVL (con1.start_date, SYSDATE - 1)