APPS.OZF_CLAIM_SETTLEMENT_PVT dependencies on OZF_CLAIMS_ALL

Line 1688: , ozf_claims_all oc

1684: -- Bug4308173
1685: CURSOR claim_gl_posting_csr(p_id in number) IS
1686: SELECT osp.post_to_gl
1687: FROM ozf_sys_parameters_all osp
1688: , ozf_claims_all oc
1689: WHERE osp.org_id = oc.org_id
1690: AND oc.claim_id = p_id;
1691: l_post_to_gl VARCHAR2(1);
1692:

Line 2526: FROM ozf_sys_parameters os, ozf_claims_all oc

2522:
2523: -- Added For Rule Based Settlement ER
2524: CURSOR csr_rule_based_approval(p_claim_id IN NUMBER) IS
2525: SELECT NVL(approval_matched_credit, 'F'),NVL(approval_new_credit,'F')
2526: FROM ozf_sys_parameters os, ozf_claims_all oc
2527: WHERE oc.org_id = os.org_id
2528: and oc.claim_id = p_claim_id;
2529:
2530: l_app_match_cr VARCHAR2(1);

Line 3130: FROM ozf_sys_parameters os, ozf_claims_all oc

3126:
3127: -- Added For Rule Based Settlement ER
3128: CURSOR csr_rule_based_approval(p_claim_id IN NUMBER) IS
3129: SELECT NVL(approval_matched_credit, 'F'),NVL(approval_new_credit,'F')
3130: FROM ozf_sys_parameters os, ozf_claims_all oc
3131: WHERE oc.org_id = os.org_id
3132: and oc.claim_id = p_claim_id;
3133:
3134: l_app_match_cr VARCHAR2(1);

Line 3474: FROM ozf_claims_all

3470: l_event_name VARCHAR2(60);
3471:
3472: CURSOR csr_claim_org(p_claim_id IN NUMBER) IS
3473: SELECT org_id
3474: FROM ozf_claims_all
3475: WHERE claim_id = p_claim_id;
3476: l_org_id NUMBER;
3477:
3478: BEGIN