APPS.CSFW_SERVICEREQUEST_PUB dependencies on OKC_K_LINES_B

Line 237: OKC_K_LINES_B BPL

233: v_contract_service_id NUMBER)
234: IS
235: SELECT BPL.Id
236: FROM OKS_K_Lines_B KSL,
237: OKC_K_LINES_B BPL
238: WHERE KSL.Cle_ID = v_contract_service_id
239: AND BPL.Cle_ID = KSL.COVERAGE_ID
240: AND BPL.Lse_Id IN (3,16,21)
241: AND EXISTS (SELECT 'x'

Line 248: from okc_k_lines_b a

244: AND Object1_Id1 = v_business_process_id
245: AND Jtot_Object1_Code = 'OKX_BUSIPROC');
246: /*
247: Select a.id
248: from okc_k_lines_b a
249: where a.lse_id in (3,16,21)
250: and exists (select 'x'
251: from okc_k_items
252: where cle_id = a.id and