APPS.CSFW_SERVICEREQUEST_PUB dependencies on OKC_K_LINES_B

Line 243: OKC_K_LINES_B BPL

239: v_contract_service_id NUMBER)
240: IS
241: SELECT BPL.Id
242: FROM OKS_K_Lines_B KSL,
243: OKC_K_LINES_B BPL
244: WHERE KSL.Cle_ID = v_contract_service_id
245: AND BPL.Cle_ID = KSL.COVERAGE_ID
246: AND BPL.Lse_Id IN (3,16,21)
247: AND EXISTS (SELECT 'x'

Line 254: from okc_k_lines_b a

250: AND Object1_Id1 = v_business_process_id
251: AND Jtot_Object1_Code = 'OKX_BUSIPROC');
252: /*
253: Select a.id
254: from okc_k_lines_b a
255: where a.lse_id in (3,16,21)
256: and exists (select 'x'
257: from okc_k_items
258: where cle_id = a.id and