APPS.CN_GET_COMM_SUMM_DATA_PVT dependencies on FND_GLOBAL

Line 60: l_user_id := FND_GLOBAL.USER_ID;

56: -- the reps assigned directly to the analyst? ***
57: -- 3) from OSC, unspecified analyst - get all reps
58: -- 4) from OSC, and salesrep - only get info for logged in rep
59:
60: l_user_id := FND_GLOBAL.USER_ID;
61: l_curr_salesrep_id := NULL;
62: OPEN get_salesrep(l_user_id,p_org_id);
63: FETCH get_salesrep INTO l_curr_salesrep_id;
64: CLOSE get_salesrep;

Line 89: l_user_id := fnd_global.user_id;

85: l_query := l_query || ' AND :b5 = 1';
86: l_user_id :=1;
87: else
88: l_query := l_query || ' AND re.user_id = :b5 ' ;
89: l_user_id := fnd_global.user_id;
90: end if;
91:
92:
93: /*

Line 95: if (fnd_global.resp_appl_id <> 283) or (l_curr_salesrep_id IS NOT NULL) then

91:
92:
93: /*
94: -- Added new or condition for enh#2648479
95: if (fnd_global.resp_appl_id <> 283) or (l_curr_salesrep_id IS NOT NULL) then
96: -- for OSO, only select user's salesrep
97: l_query := l_query || ' AND re.user_id = :b4 ' ;
98: l_user_id := fnd_global.user_id;
99: elsif (p_analyst_id <> -99) then

Line 98: l_user_id := fnd_global.user_id;

94: -- Added new or condition for enh#2648479
95: if (fnd_global.resp_appl_id <> 283) or (l_curr_salesrep_id IS NOT NULL) then
96: -- for OSO, only select user's salesrep
97: l_query := l_query || ' AND re.user_id = :b4 ' ;
98: l_user_id := fnd_global.user_id;
99: elsif (p_analyst_id <> -99) then
100: -- we specified an analyst ID
101: l_query := l_query || ' AND s.assigned_to_user_id = :b4 ' ;
102: l_user_id := p_analyst_id;

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