APPS.OZF_CLAIM_SETTLEMENT_PVT dependencies on OZF_CLAIMS

Line 265: FROM ozf_claims

261: , cust_account_id
262: , cust_billto_acct_site_id
263: , vendor_id
264: , vendor_site_id
265: FROM ozf_claims
266: WHERE claim_id = p_id;
267:
268: l_payment_method VARCHAR2(30);
269: l_cust_account_id NUMBER;

Line 596: FROM ozf_claims

592: l_return_status VARCHAR2(1);
593:
594: CURSOR csr_claim_class(cv_claim_id IN NUMBER) IS
595: SELECT claim_class
596: FROM ozf_claims
597: WHERE claim_id = cv_claim_id;
598:
599: l_claim_class VARCHAR2(30);
600:

Line 752: FROM ozf_claims

748: l_return_status VARCHAR2(1);
749:
750: CURSOR csr_claim_class(cv_claim_id IN NUMBER) IS
751: SELECT claim_class
752: FROM ozf_claims
753: WHERE claim_id = cv_claim_id;
754:
755: l_claim_class VARCHAR2(30);
756:

Line 1142: FROM ozf_claims

1138: SELECT object_version_number
1139: --, user_status_id
1140: , settled_by -- Fix for Bug 4754509
1141: , comments
1142: FROM ozf_claims
1143: WHERE claim_id = l_claim_id;
1144:
1145: BEGIN
1146: IF OZF_DEBUG_HIGH_ON THEN

Line 1657: FROM ozf_claims

1653: , gl_date
1654: , claim_class
1655: , payment_reference_id
1656: , source_object_class
1657: FROM ozf_claims
1658: WHERE claim_id = cv_claim_id;
1659:
1660: CURSOR csr_payment_ref_settlement(cv_customer_trx_id IN NUMBER) IS
1661: SELECT cust_trx_type_id

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 2210: FROM ozf_claims

2206: , payment_method
2207: , write_off_flag
2208: , under_write_off_threshold
2209: , status_code
2210: FROM ozf_claims
2211: WHERE claim_id = cv_claim_id;
2212:
2213: l_claim_approval_attr csr_claim_approval_attr%ROWTYPE;
2214: BEGIN

Line 2520: FROM ozf_claims

2516: l_approval_require VARCHAR2(1);
2517:
2518: CURSOR csr_claim_prev_status(cv_claim_id IN NUMBER) IS
2519: SELECT status_code
2520: FROM ozf_claims
2521: WHERE claim_id = cv_claim_id;
2522:
2523: -- Added For Rule Based Settlement ER
2524: CURSOR csr_rule_based_approval(p_claim_id IN NUMBER) IS

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 3121: FROM ozf_claims

3117: , status_code
3118: , settled_from
3119: , payment_reference_number
3120: , payment_reference_id
3121: FROM ozf_claims
3122: WHERE claim_id = cv_claim_id;
3123:
3124: l_claim_approval_attr csr_claim_approval_attr%ROWTYPE;
3125: l_approval_require 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