DBA Data[Home] [Help]

APPS.CN_GET_COMM_SUMM_DATA dependencies on FND_GLOBAL

Line 26: WHERE re.user_id = fnd_global.user_id

22: cn_comp_plans plan,
23: cn_roles role,
24: cn_period_statuses ps,
25: jtf_rs_resource_extns re
26: WHERE re.user_id = fnd_global.user_id
27: AND re.resource_id = rep.resource_id
28: AND rep.assigned_to_user_id = u.user_id (+)
29: AND assign.salesrep_id = rep.salesrep_id
30: AND ps.period_id = p_period_id

Line 311: if (fnd_global.resp_appl_id <> 283) then

307: WHERE period_year = mod(floor(p_period_id/1000),10000);
308:
309: x_total_rows := 0;
310:
311: if (fnd_global.resp_appl_id <> 283) then
312: -- we are in oracle sales, use main_cur
313: FOR main IN main_cur(p_period_id) LOOP
314: x_total_rows := x_total_rows + 1;
315: if x_total_rows between p_first and p_last then