DBA Data[Home] [Help]

APPS.DPP_UTILITY_PVT dependencies on DPP_TRANSACTION_CLAIMS_ALL

Line 18: dpp_transaction_claims_all dtcl

14: CURSOR select_claims_csr(p_transaction_header_id IN VARCHAR2)
15: IS
16: SELECT ocl.claim_number
17: FROM ozf_claims_all ocl,
18: dpp_transaction_claims_all dtcl
19: WHERE dtcl.transaction_header_id = p_transaction_header_id
20: AND dtcl.claim_type IN('SUPP_CUST_CL','SUPP_DSTR_CL','SUPP_DSTR_INC_CL','CUST_CL')
21: AND dtcl.claim_id = ocl.claim_id
22: AND ocl.status_code <> 'CLOSED';