APPS.OZF_CLAIM_SETTLEMENT_PVT dependencies on OZF_CLAIMS

Line 263: FROM ozf_claims

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

Line 594: FROM ozf_claims

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

Line 750: FROM ozf_claims

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

Line 1140: FROM ozf_claims

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

Line 1655: FROM ozf_claims

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

Line 1686: , ozf_claims_all oc

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

Line 2197: FROM ozf_claims

2193: , payment_method
2194: , write_off_flag
2195: , under_write_off_threshold
2196: , status_code
2197: FROM ozf_claims
2198: WHERE claim_id = cv_claim_id;
2199:
2200: l_claim_approval_attr csr_claim_approval_attr%ROWTYPE;
2201: BEGIN

Line 2285: FROM ozf_claims

2281: l_approval_require VARCHAR2(1);
2282:
2283: CURSOR csr_claim_prev_status(cv_claim_id IN NUMBER) IS
2284: SELECT status_code
2285: FROM ozf_claims
2286: WHERE claim_id = cv_claim_id;
2287:
2288: BEGIN
2289: --------------------- initialize -----------------------

Line 2789: FROM ozf_claims

2785: , payment_method
2786: , write_off_flag
2787: , under_write_off_threshold
2788: , status_code
2789: FROM ozf_claims
2790: WHERE claim_id = cv_claim_id;
2791:
2792: l_claim_approval_attr csr_claim_approval_attr%ROWTYPE;
2793: l_approval_require VARCHAR2(1);

Line 3097: FROM ozf_claims_all

3093: l_event_name VARCHAR2(60);
3094:
3095: CURSOR csr_claim_org(p_claim_id IN NUMBER) IS
3096: SELECT org_id
3097: FROM ozf_claims_all
3098: WHERE claim_id = p_claim_id;
3099: l_org_id NUMBER;
3100:
3101: BEGIN