[Home] [Help]
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
71: AND GPM.RESOURCE_ID = l_resource_id;
72:
202: l_count NUMBER :=0;
203: cursor cur_salesreps
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')
640: AND assign.org_id = cp.org_id
641: and assign.org_id = c_org_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')
913: AND assign.comp_plan_id = cp.comp_plan_id
914: AND assign.org_id = cp.org_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')