APPS.CN_GET_COMM_SUMM_DATA_PVT dependencies on CN_SYSTEM_PARAMETERS

Line 211: AND U.USAGE=CN_SYSTEM_PARAMETERS.VALUE('CN_REPORTING_HIERARCHY',p_org_id)

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
213: AND (RM.END_DATE_ACTIVE IS NULL OR (RM.END_DATE_ACTIVE >= SYSDATE))
214: AND DENORM_LEVEL IS NOT NULL AND S.org_id =p_org_id;
215:

Line 649: AND U.USAGE=CN_SYSTEM_PARAMETERS.VALUE('CN_REPORTING_HIERARCHY',c_org_id)

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
651: AND (RM.END_DATE_ACTIVE IS NULL OR (RM.END_DATE_ACTIVE >= SYSDATE))
652: AND DENORM_LEVEL IS NOT NULL AND S.ORG_ID =c_org_id)
653: ORDER BY assign.start_date ;

Line 922: AND U.USAGE=CN_SYSTEM_PARAMETERS.VALUE('CN_REPORTING_HIERARCHY',c_org_id)

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
924: AND (RM.END_DATE_ACTIVE IS NULL OR (RM.END_DATE_ACTIVE >= SYSDATE))
925: AND DENORM_LEVEL IS NOT NULL AND S.ORG_ID = c_org_id
926: )