APPS.OKS_BILLING_PUB dependencies on OKC_K_GRPINGS

Line 6626: from OKC_K_GRPINGS grp

6622: where osb.ste_code <> 'HOLD'
6623: ) sts,
6624: (
6625: Select /*+ FULL (grp) no_merge */ distinct included_chr_id
6626: from OKC_K_GRPINGS grp
6627: where grp.cgp_parent_id = p_grp_id
6628: ) cgp
6629: WHERE Hdr.id = line.dnz_chr_id
6630: AND Hdr.scs_code in ('SERVICE','WARRANTY','SUBSCRIPTION')

Line 6674: from OKC_K_GRPINGS grp

6670: where osb.ste_code <> 'HOLD'
6671: ) sts,
6672: (
6673: Select /*+ FULL (grp) no_merge */ distinct included_chr_id
6674: from OKC_K_GRPINGS grp
6675: where grp.cgp_parent_id = p_grp_id
6676: ) cgp
6677: WHERE Hdr.id = line.dnz_chr_id
6678: AND Hdr.scs_code in ('SERVICE','WARRANTY','SUBSCRIPTION')

Line 6783: (select 1 from OKC_K_GRPINGS okg

6779: where okp.dnz_chr_id = hdr.id
6780: and okp.rle_code in ('CUSTOMER','SUBSCRIBER')
6781: and okp.object1_id1 = nvl(P_customer_id, okp.object1_id1) )
6782: AND exists
6783: (select 1 from OKC_K_GRPINGS okg
6784: where okg.included_chr_id = hdr.id
6785: and okg.cgp_parent_id = nvl(p_grp_id, okg.cgp_parent_id) )
6786: AND line.id IN (Select lvl.parent_cle_id
6787: from oks_level_elements lvl