APPS.OKS_BILLING_PUB dependencies on OKC_K_PARTY_ROLES_B

Line 2334: OKC_K_PARTY_ROLES_B okp

2330: ,rul.price_uom
2331: ,nvl(rul.summary_trx_yn,'N') summary_yn
2332: ,rline.settlement_interval
2333: FROM
2334: OKC_K_PARTY_ROLES_B okp
2335: ,OKC_K_LINES_B line
2336: ,OKS_K_LINES_B rline
2337: ,OKC_K_HEADERS_B Hdr
2338: ,OKS_K_HEADERS_B rul

Line 3285: (select 1 from OKC_K_PARTY_ROLES_B okp

3281: AND Hdr.Template_yn = 'N'
3282: AND Hdr.Authoring_Org_Id = nvl(l_org_id, hdr.authoring_org_id)
3283: AND Hdr.Scs_code = nvl(p_category, hdr.scs_code)
3284: AND exists
3285: (select 1 from OKC_K_PARTY_ROLES_B okp
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