APPS.CN_GET_COMM_SUMM_DATA_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 32: 'SELECT distinct s.name, s.salesrep_id FROM jtf_rs_resource_extns re,

28: l_groupquery_result number;
29: l_rolequery_result number;
30:
31: l_query varchar2(4000) :=
32: 'SELECT distinct s.name, s.salesrep_id FROM jtf_rs_resource_extns re,
33: cn_salesreps s,cn_srp_plan_assigns assign WHERE re.resource_id = s.resource_id
34: and s.org_id = assign.org_id and re.category <> ''TBH''
35: and s.salesrep_id > 0 and s.salesrep_id = assign.salesrep_id
36: and :b1 <= nvl(assign.end_date, :b2)

Line 45: from cn_rs_salesreps s, jtf_rs_resource_extns re

41: where period_id = p_period_id and org_id=p_org_id;
42:
43: cursor get_salesrep (a_user_id number,a_org_id number) is
44: select s.salesrep_id
45: from cn_rs_salesreps s, jtf_rs_resource_extns re
46: where re.user_id = a_user_id and s.resource_id = re.resource_id
47: and s.org_id = a_org_id;
48:
49: BEGIN

Line 66: select je.resource_id into l_resource_id from jtf_rs_resource_extns je where je.user_id =l_user_id;

62: OPEN get_salesrep(l_user_id,p_org_id);
63: FETCH get_salesrep INTO l_curr_salesrep_id;
64: CLOSE get_salesrep;
65:
66: select je.resource_id into l_resource_id from jtf_rs_resource_extns je where je.user_id =l_user_id;
67:
68: SELECT count(1) into l_groupquery_result FROM JTF_RS_GROUP_MBR_ROLE_VL GPM, JTF_RS_GROUP_USAGES GPU
69: WHERE GPM.GROUP_ID=GPU.GROUP_ID and GPU.usage='COMP_PAYMENT'
70: AND NVL(GPM.END_DATE_ACTIVE,TO_DATE('01/01/9999','DD/MM/RRRR')) >= SYSDATE

Line 208: FROM JTF_RS_RESOURCE_EXTNS R WHERE R.USER_ID = FND_GLOBAL.USER_ID)

204: is
205: SELECT DISTINCT S.SALESREP_ID,S.ORG_ID
206: FROM JTF_RS_REP_MANAGERS RM,JTF_RS_GROUP_USAGES U, CN_SALESREPS S WHERE
207: RM.PARENT_RESOURCE_ID=(SELECT R.RESOURCE_ID
208: FROM JTF_RS_RESOURCE_EXTNS R WHERE R.USER_ID = FND_GLOBAL.USER_ID)
209: AND RM.RESOURCE_ID=S.RESOURCE_ID
210: AND RM.HIERARCHY_TYPE IN ('MGR_TO_REP', 'REP_TO_REP', 'MGR_TO_MGR')
211: AND U.USAGE=CN_SYSTEM_PARAMETERS.VALUE('CN_REPORTING_HIERARCHY',p_org_id)
212: AND RM.GROUP_ID = U.GROUP_ID AND SYSDATE >= RM.START_DATE_ACTIVE

Line 646: FROM JTF_RS_RESOURCE_EXTNS R WHERE R.USER_ID = FND_GLOBAL.USER_ID)

642: AND assign.salesrep_id in
643: (SELECT DISTINCT S.SALESREP_ID
644: FROM JTF_RS_REP_MANAGERS RM,JTF_RS_GROUP_USAGES U, CN_SALESREPS S WHERE
645: RM.PARENT_RESOURCE_ID=(SELECT R.RESOURCE_ID
646: FROM JTF_RS_RESOURCE_EXTNS R WHERE R.USER_ID = FND_GLOBAL.USER_ID)
647: AND RM.RESOURCE_ID=S.RESOURCE_ID
648: AND RM.HIERARCHY_TYPE IN ('MGR_TO_REP', 'REP_TO_REP', 'MGR_TO_MGR')
649: AND U.USAGE=CN_SYSTEM_PARAMETERS.VALUE('CN_REPORTING_HIERARCHY',c_org_id)
650: AND RM.GROUP_ID = U.GROUP_ID AND SYSDATE >= RM.START_DATE_ACTIVE

Line 919: FROM JTF_RS_RESOURCE_EXTNS R WHERE R.USER_ID = FND_GLOBAL.USER_ID)

915: and assign.org_id = c_org_id
916: AND assign.salesrep_id in (SELECT DISTINCT S.SALESREP_ID
917: FROM JTF_RS_REP_MANAGERS RM,JTF_RS_GROUP_USAGES U, CN_SALESREPS S WHERE
918: RM.PARENT_RESOURCE_ID=(SELECT R.RESOURCE_ID
919: FROM JTF_RS_RESOURCE_EXTNS R WHERE R.USER_ID = FND_GLOBAL.USER_ID)
920: AND RM.RESOURCE_ID=S.RESOURCE_ID
921: AND RM.HIERARCHY_TYPE IN ('MGR_TO_REP', 'REP_TO_REP', 'MGR_TO_MGR')
922: AND U.USAGE=CN_SYSTEM_PARAMETERS.VALUE('CN_REPORTING_HIERARCHY',c_org_id)
923: AND RM.GROUP_ID = U.GROUP_ID AND SYSDATE >= RM.START_DATE_ACTIVE