APPS.OKC_DBTREE_PVT dependencies on FND_GLOBAL

Line 384: OR (g.public_yn = decode(gflag,'P','N') AND user_id = FND_GLOBAL.USER_ID)

380: where NOT EXISTS (select 1
381: from okc_k_grpings_v p
382: where p.included_cgp_id = g.id)
383: AND ( (g.public_yn = decode(gflag,'U','Y','A','Y'))
384: OR (g.public_yn = decode(gflag,'P','N') AND user_id = FND_GLOBAL.USER_ID)
385: OR (gflag = 'A' AND user_id = FND_GLOBAL.USER_ID)
386: )
387: ORDER BY g.name;
388: */

Line 385: OR (gflag = 'A' AND user_id = FND_GLOBAL.USER_ID)

381: from okc_k_grpings_v p
382: where p.included_cgp_id = g.id)
383: AND ( (g.public_yn = decode(gflag,'U','Y','A','Y'))
384: OR (g.public_yn = decode(gflag,'P','N') AND user_id = FND_GLOBAL.USER_ID)
385: OR (gflag = 'A' AND user_id = FND_GLOBAL.USER_ID)
386: )
387: ORDER BY g.name;
388: */
389: -- The cursor has been modified by manash to take care of public/private grouping problem Bug#1159200

Line 414: AND g1.public_yn = 'N' and g1.user_id = FND_GLOBAL.USER_ID

410: select 1
411: from okc_k_grpings_v p, okc_k_groups_v g1
412: where p.included_cgp_id = g.id
413: and g1.id = p.cgp_parent_id
414: AND g1.public_yn = 'N' and g1.user_id = FND_GLOBAL.USER_ID
415: )
416: AND ( (g.public_yn = decode(gflag,'U','Y','A','Y'))
417: OR (g.public_yn = decode(gflag,'P','N') AND user_id = FND_GLOBAL.USER_ID)
418: OR (gflag = 'A' AND user_id = FND_GLOBAL.USER_ID)

Line 417: OR (g.public_yn = decode(gflag,'P','N') AND user_id = FND_GLOBAL.USER_ID)

413: and g1.id = p.cgp_parent_id
414: AND g1.public_yn = 'N' and g1.user_id = FND_GLOBAL.USER_ID
415: )
416: AND ( (g.public_yn = decode(gflag,'U','Y','A','Y'))
417: OR (g.public_yn = decode(gflag,'P','N') AND user_id = FND_GLOBAL.USER_ID)
418: OR (gflag = 'A' AND user_id = FND_GLOBAL.USER_ID)
419: )
420: ORDER BY g.name;
421:

Line 418: OR (gflag = 'A' AND user_id = FND_GLOBAL.USER_ID)

414: AND g1.public_yn = 'N' and g1.user_id = FND_GLOBAL.USER_ID
415: )
416: AND ( (g.public_yn = decode(gflag,'U','Y','A','Y'))
417: OR (g.public_yn = decode(gflag,'P','N') AND user_id = FND_GLOBAL.USER_ID)
418: OR (gflag = 'A' AND user_id = FND_GLOBAL.USER_ID)
419: )
420: ORDER BY g.name;
421:
422: