APPS.OZF_CLAIM_LINE_PVT dependencies on OZF_CLAIMS_ALL

Line 1004: FROM ozf_claims_all

1000: , amount
1001: , payment_method
1002: , vendor_id
1003: , vendor_site_id
1004: FROM ozf_claims_all
1005: WHERE claim_id = p_claim_id;
1006:
1007: CURSOR csr_line_rec_upd IS
1008: SELECT claim_line_id

Line 1689: ozf_claims_all oc

1685: SELECT
1686: orb.batch_type
1687: FROM
1688: ozf_resale_batches_all orb,
1689: ozf_claims_all oc
1690: WHERE
1691: oc.batch_id = orb.resale_batch_id
1692: AND oc.claim_id = p_claim_id;
1693: --Bug# 7319828 fixed by ateotia(-)

Line 4607: ozf_claims_all oc

4603:
4604: CURSOR csr_claim_settle_method(cv_claim_id IN NUMBER) IS
4605: SELECT ocs.tax_for
4606: FROM ozf_claim_sttlmnt_methods_all ocs,
4607: ozf_claims_all oc
4608: WHERE claim_id = cv_claim_id
4609: AND ocs.claim_class = oc.claim_class
4610: AND NVL(ocs.source_object_class,'NULL') = NVL(oc.source_object_class,'NULL')
4611: AND ocs.settlement_method = oc.payment_method ;

Line 5521: FROM ozf_claims_all

5517:
5518:
5519: CURSOR csr_claim_status(cv_claim_id IN NUMBER) IS
5520: SELECT status_code
5521: FROM ozf_claims_all
5522: WHERE claim_id = cv_claim_id;
5523:
5524: -- added for bugfix 5075837 to get max line number
5525: CURSOR c_line_number(cv_claim_id IN NUMBER) IS