APPS.CN_WKSHT_GET_PUB dependencies on FND_GLOBAL

Line 269: WHERE re1.user_id = fnd_global.user_id

265: FROM jtf_rs_resource_extns re1,
266: cn_period_statuses pr,
267: jtf_rs_group_usages u1,
268: jtf_rs_rep_managers m1
269: WHERE re1.user_id = fnd_global.user_id
270: AND (pr.period_id, pr.org_id) = (
271: SELECT pay_period_id, org_id
272: FROM cn_payruns
273: WHERE payrun_id = p_payrun_id)

Line 336: l_b7 := fnd_global.user_id;

332: END IF;
333:
334: IF p_my_analyst = 'Y' THEN
335: l_where := l_where || ' and ( ' || l_where7 || ') ';
336: l_b7 := fnd_global.user_id;
337: l_b8 := p_payrun_id;
338: ELSE
339: l_where := l_where || ' and ( 1 = :B7 ) and 1 = :B8 ';
340: l_b7 := 1;

Line 348: l_b9 := fnd_global.user_id;

344: -- Bug 3597600: p_my_analyst can be NULL
345: -- Old code: p_my_analyst = 'N' THEN
346: IF (p_analyst_name IS NULL OR p_analyst_name = '%') AND
347: (p_my_analyst = 'N' OR p_my_analyst IS NULL) THEN
348: l_b9 := fnd_global.user_id;
349: l_where := l_where || ' and assigned_to_user_id = :B11 ' ;
350: ELSE
351: l_where := l_where || ' and 1 = :B11 ' ;
352: l_b9 := 1;