DBA Data[Home] [Help]

APPS.OZF_CLAIM_LINE_PVT dependencies on OZF_CLAIMS_ALL

Line 4174: ozf_claims_all oc

4170:
4171: CURSOR csr_claim_settle_method(cv_claim_id IN NUMBER) IS
4172: SELECT ocs.tax_for
4173: FROM ozf_claim_sttlmnt_methods_all ocs,
4174: ozf_claims_all oc
4175: WHERE claim_id = cv_claim_id
4176: AND ocs.claim_class = oc.claim_class
4177: AND NVL(ocs.source_object_class,'NULL') = NVL(oc.source_object_class,'NULL')
4178: AND ocs.settlement_method = oc.payment_method ;

Line 5088: FROM ozf_claims_all

5084:
5085:
5086: CURSOR csr_claim_status(cv_claim_id IN NUMBER) IS
5087: SELECT status_code
5088: FROM ozf_claims_all
5089: WHERE claim_id = cv_claim_id;
5090:
5091: -- added for bugfix 5075837 to get max line number
5092: CURSOR c_line_number(cv_claim_id IN NUMBER) IS