APPS.OKS_BILLING_PUB dependencies on OKC_K_GRPINGS

Line 3253: from OKC_K_GRPINGS grp

3249: where osb.ste_code <> 'HOLD'
3250: ) sts,
3251: (
3252: Select /*+ FULL (grp) no_merge */ distinct included_chr_id
3253: from OKC_K_GRPINGS grp
3254: where grp.cgp_parent_id = p_grp_id
3255: ) cgp
3256: WHERE Hdr.id = line.dnz_chr_id
3257: AND Hdr.scs_code in ('SERVICE','WARRANTY','SUBSCRIPTION')

Line 3290: (select 1 from OKC_K_GRPINGS okg

3286: where okp.dnz_chr_id = hdr.id
3287: and okp.rle_code in ('CUSTOMER','SUBSCRIBER')
3288: and okp.object1_id1 = nvl(P_customer_id, okp.object1_id1) )
3289: AND exists
3290: (select 1 from OKC_K_GRPINGS okg
3291: where okg.included_chr_id = hdr.id
3292: and okg.cgp_parent_id = nvl(p_grp_id, okg.cgp_parent_id) )
3293: AND line.id IN (Select lvl.parent_cle_id
3294: from oks_level_elements lvl