APPS.OZF_CLAIM_INSTALL dependencies on OZF_CLAIMS_ALL

Line 98: FROM ozf_claims_all

94: , status_code
95: , NVL(SUM(amount_remaining + amount_settled),0)
96: , NVL(SUM(acctd_amount_remaining + acctd_amount_settled),0)
97: , currency_code
98: FROM ozf_claims_all
99: WHERE root_claim_id = cv_claim_id
100: GROUP BY claim_id, payment_method, status_code, currency_code;
101:
102: CURSOR csr_settlement_amount(cv_claim_id IN NUMBER) IS