DBA Data[Home] [Help]

APPS.CSFW_SERVICEREQUEST_PUB dependencies on OKS_K_LINES_B

Line 242: FROM OKS_K_Lines_B KSL,

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