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 423: , ozf_claims c

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

Line 609: ozf_claims_all oc

605: -- R12: Earnings are supported for custom settlement
606: CURSOR csr_payment_type(cv_claim_id IN NUMBER) IS
607: SELECT ocs.seeded_flag
608: FROM ozf_claim_sttlmnt_methods_all ocs,
609: ozf_claims_all oc
610: WHERE claim_id = cv_claim_id
611: AND ocs.claim_class = oc.claim_class
612: AND NVL(ocs.source_object_class,'NULL') = NVL(oc.source_object_class,'NULL')
613: AND ocs.settlement_method = oc.payment_method ;