APPS.OKC_DBTREE_PVT dependencies on OKC_K_GRPINGS_V

Line 361: from okc_k_grpings_v p

357: creation_date,
358: okc_query.GetChildCount(id) numchildren
359: from okc_k_groups_v g
360: where NOT EXISTS (select 1
361: from okc_k_grpings_v p
362: where p.included_cgp_id = g.id)
363: AND ( (g.public_yn = decode(gflag,'U','Y',gflag,'A','Y'))
364: OR (g.public_yn = decode(gflag,'P','N') AND created_by = 10589)
365: OR (gflag = 'A' AND created_by = 10589)

Line 381: from okc_k_grpings_v p

377: creation_date,
378: okc_query.GetChildCount(id) numchildren
379: from okc_k_groups_v g
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)

Line 403: from okc_k_grpings_v p, okc_k_groups_v g1

399: okc_query.GetChildCount(id) numchildren
400: from okc_k_groups_v g
401: where NOT EXISTS (
402: select 1
403: from okc_k_grpings_v p, okc_k_groups_v g1
404: where p.included_cgp_id = g.id
405: and g1.id = p.cgp_parent_id
406: and g1.public_yn = 'Y'
407:

Line 411: from okc_k_grpings_v p, okc_k_groups_v g1

407:
408: UNION
409:
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: )