DBA Data[Home] [Help]

APPS.DPP_UTILITY_PVT dependencies on OZF_CLAIMS_ALL

Line 17: FROM ozf_claims_all ocl,

13:
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