DBA Data[Home] [Help]

APPS.CSFW_SERVICEREQUEST_PUB dependencies on OKS_K_LINES_B

Line 236: FROM OKS_K_Lines_B KSL,

232: CURSOR C_TXN_GROUP_ID(v_business_process_id NUMBER,
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)