APPS.OZF_CLAIM_INSTALL dependencies on OZF_CLAIMS_ALL

Line 100: FROM ozf_claims_all

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