APPS.OZF_CLAIM_PUB dependencies on OZF_CLAIMS_ALL

Line 674: FROM ozf_claims_all

670: -- Added for Bug 6727136
671: --Fix for Bug 13346665
672: CURSOR Claim_Source_csr(p_claim_id in number) IS
673: SELECT NVL(source_object_class,'NULL')
674: FROM ozf_claims_all
675: WHERE claim_id = p_claim_id;
676:
677: l_source_object_class VARCHAR2(30);
678:

Line 2896: FROM ozf_claims_all

2892: l_sum_split_amt NUMBER;
2893:
2894: CURSOR parent_claim_id_csr(cv_parent_claim_id IN NUMBER) IS
2895: SELECT claim_id,object_version_number,status_code,amount_remaining
2896: FROM ozf_claims_all
2897: WHERE claim_id = cv_parent_claim_id;
2898:
2899: CURSOR claim_type_id_csr(cv_claim_type_id IN NUMBER) IS
2900: SELECT claim_type_id

Line 3238: FROM ozf_claims_all

3234: CURSOR csr_claim_info(cv_claim_id IN NUMBER)IS
3235: SELECT claim_id
3236: ,status_code
3237: ,payment_method
3238: FROM ozf_claims_all
3239: WHERE claim_id = cv_claim_id;
3240:
3241: CURSOR csr_is_promo_claim(cv_claim_id IN NUMBER)IS
3242: SELECT COUNT(clu.claim_line_util_id)

Line 3257: FROM ozf_claim_sttlmnt_methods_all csm,ozf_claims_all c

3253: GROUP BY reversal_flag;
3254:
3255: CURSOR taxfor_csr (p_claim_id IN NUMBER)IS
3256: SELECT tax_for
3257: FROM ozf_claim_sttlmnt_methods_all csm,ozf_claims_all c
3258: WHERE csm.settlement_method = c.payment_method
3259: AND c.claim_id =p_claim_id
3260: AND csm.org_id = c.org_id;
3261:

Line 3281: , ozf_claims_all oc

3277:
3278: CURSOR claim_gl_posting_csr(p_id in number) IS
3279: SELECT NVL(osp.post_to_gl, 'F')
3280: FROM ozf_sys_parameters_all osp
3281: , ozf_claims_all oc
3282: WHERE osp.org_id = oc.org_id
3283: AND oc.claim_id = p_id;
3284:
3285: BEGIN