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 4011: ,jtf_rs_salesreps srp

4007: /* Cursor l_salesgroup_csr(p_salesrep_id Number) Is
4008: SELECT DISTINCT grp.group_name, grp.group_id
4009: FROM jtf_rs_group_members mem
4010: ,jtf_rs_groups_vl grp
4011: ,jtf_rs_salesreps srp
4012: ,jtf_rs_group_usages usg
4013: ,jtf_rs_role_relations rrl
4014: WHERE srp.resource_id = mem.resource_id
4015: AND mem.group_id = grp.group_id

Line 4968: FROM jtf_rs_resource_extns re, jtf_rs_salesreps sr

4964: IS
4965: CURSOR l_get_source_csr (p_salesrep_id NUMBER, p_authorg_id NUMBER)
4966: IS
4967: SELECT source_id
4968: FROM jtf_rs_resource_extns re, jtf_rs_salesreps sr
4969: WHERE sr.resource_id = re.resource_id
4970: AND sr.salesrep_id = p_salesrep_id
4971: AND (sr.org_id = p_authorg_id OR p_authorg_id IS NULL);
4972:

Line 5655: FROM okc_contacts con1, jtf_rs_salesreps salesrep

5651: p_org_id IN NUMBER
5652: )
5653: IS
5654: SELECT con1.ID
5655: FROM okc_contacts con1, jtf_rs_salesreps salesrep
5656: WHERE con1.dnz_chr_id = p_contract_id
5657: AND jtot_object1_code = 'OKX_SALEPERS'
5658: AND con1.cpl_id = p_party_id
5659: AND TRUNC (SYSDATE) BETWEEN NVL (con1.start_date, SYSDATE - 1)