DBA Data[Home] [Help]

APPS.OKC_UTIL dependencies on OKC_K_GROUPS_TL

Line 3145: from okc_k_groups_tl g

3141: d number;
3142: v number := fnd_profile.value('OKC_PERCENT_FOR_IDX');
3143: begin
3144: select sum(OKC_UTIL.get_prcnt('OKC','OKC_K_GRPINGS','CGP_PARENT_ID',g.id)) into d
3145: from okc_k_groups_tl g
3146: where g.name like p_grp_like and g.language=userenv('LANG');
3147: if (d is NULL or d<=v) then return 0;
3148: else return 1;
3149: end if;