DBA Data[Home] [Help]

APPS.CSM_CONTRACT_EVENT_PKG dependencies on OKC_K_LINES_B

Line 60: OKC_K_LINES_B BPL

56: CURSOR c_get_cov_id(c_contract_service_id IN NUMBER, c_business_process_id in number)
57: IS
58: SELECT BPL.Id
59: FROM OKS_K_Lines_B KSL,
60: OKC_K_LINES_B BPL
61: WHERE KSL.Cle_ID = c_contract_service_id
62: AND BPL.Cle_ID = KSL.COVERAGE_ID
63: AND BPL.Lse_Id IN (3,16,21)
64: AND EXISTS (SELECT 'x'

Line 491: , okc_k_lines_b l

487: , s.name
488: , s.description
489: , l.currency_code
490: FROM okc_k_headers_all_b h
491: , okc_k_lines_b l
492: , Okx_System_Items_V s
493: , Okc_K_Items IT
494: , CS_INCIDENTS_ALL_B cs
495: WHERE cs.INCIDENT_ID = b_incident_id