APPS.OZF_CLAIM_SETTLEMENT_VAL_PVT dependencies on OZF_CLAIMS

Line 40: FROM ozf_claims

36: l_return_status VARCHAR2(1);
37:
38: CURSOR csr_settlement_method(cv_claim_id IN NUMBER) IS
39: SELECT payment_method
40: FROM ozf_claims
41: WHERE claim_id = cv_claim_id;
42:
43: l_settlement_method VARCHAR2(30);
44:

Line 132: FROM ozf_claims

128: l_return_status VARCHAR2(1);
129:
130: CURSOR csr_settlement_method(cv_claim_id IN NUMBER) IS
131: SELECT payment_method
132: FROM ozf_claims
133: WHERE claim_id = cv_claim_id;
134:
135: l_claim_line_rec OZF_CLAIM_LINE_PVT.claim_line_rec_type;
136: l_settlement_method VARCHAR2(30);

Line 240: FROM ozf_claims

236: l_return_status VARCHAR2(1);
237:
238: CURSOR csr_settlement_method(cv_claim_id IN NUMBER) IS
239: SELECT payment_method
240: FROM ozf_claims
241: WHERE claim_id = cv_claim_id;
242:
243: l_error BOOLEAN := FALSE;
244: l_settlement_method VARCHAR2(30);

Line 325: FROM ozf_claims

321: l_return_status VARCHAR2(1);
322:
323: CURSOR csr_settlement_method(cv_claim_id IN NUMBER) IS
324: SELECT payment_method
325: FROM ozf_claims
326: WHERE claim_id = cv_claim_id;
327:
328: i NUMBER;
329: l_error BOOLEAN := FALSE;

Line 426: , ozf_claims c

422: , cv_claim_id IN NUMBER
423: ) IS
424: SELECT DECODE(MAX(gl.period_name), '', 0, 1)
425: FROM gl_period_statuses gl
426: , ozf_claims c
427: WHERE gl.application_id = cv_app_id
428: AND c.claim_id= cv_claim_id
429: AND gl.set_of_books_id = c.set_of_books_id
430: AND gl.adjustment_period_flag = 'N'

Line 441: , ozf_claims c

437: , cv_gl_date IN DATE
438: ) IS
439: SELECT DECODE(MAX(gl.period_name), '', 0, 1)
440: FROM gl_period_statuses gl
441: , ozf_claims c
442: WHERE gl.application_id = cv_app_id
443: AND c.claim_id= cv_claim_id
444: AND gl.set_of_books_id = c.set_of_books_id
445: AND gl.adjustment_period_flag = 'N'

Line 652: ozf_claims_all oc

648: -- R12: Earnings are supported for custom settlement
649: CURSOR csr_payment_type(cv_claim_id IN NUMBER) IS
650: SELECT ocs.seeded_flag
651: FROM ozf_claim_sttlmnt_methods_all ocs,
652: ozf_claims_all oc
653: WHERE claim_id = cv_claim_id
654: AND ocs.claim_class = oc.claim_class
655: AND NVL(ocs.source_object_class,'NULL') = NVL(oc.source_object_class,'NULL')
656: AND ocs.settlement_method = oc.payment_method ;