APPS.OZF_SPLIT_CLAIM_PVT dependencies on OZF_CLAIMS_ALL

Line 81: FROM OZF_CLAIMS_ALL

77: l_split_status_type VARCHAR2(30);
78:
79: CURSOR parent_claim_csr(p_id in number) IS
80: SELECT *
81: FROM OZF_CLAIMS_ALL
82: WHERE claim_id = p_id;
83: l_parent_claim parent_claim_csr%ROWTYPE;
84:
85: -- [BEGIN OF BUG 3473501 FIXING]

Line 403: FROM ozf_claims_all

399: l_object_version_number NUMBER;
400:
401: CURSOR version_csr (p_id in number) IS
402: SELECT object_version_number
403: FROM ozf_claims_all
404: WHERE claim_id = p_id;
405:
406: CURSOR status_code_csr(p_id in number) IS
407: SELECT status_code

Line 408: FROM ozf_claims_all

404: WHERE claim_id = p_id;
405:
406: CURSOR status_code_csr(p_id in number) IS
407: SELECT status_code
408: FROM ozf_claims_all
409: WHERE claim_id = p_id;
410: l_status_code VARCHAR(30);
411:
412: CURSOR line_amount_sum_csr(p_id in number) IS

Line 584: FROM ozf_claims_all

580: l_line_obj_num NUMBER;
581:
582: CURSOR claim_info_csr (p_id in number) IS
583: SELECT object_version_number, status_code, amount_adjusted, amount_remaining, currency_code, reason_code_id
584: FROM ozf_claims_all
585: WHERE claim_id = p_id;
586: l_object_version_number NUMBER;
587: l_status_code varchar2(30);
588: l_amount_adjusted number;

Line 735: FROM ozf_claims_all

731: l_msg_count NUMBER;
732:
733: CURSOR amount_csr(p_id in NUMBER) IS
734: SELECT amount_remaining
735: FROM ozf_claims_all
736: WHERE claim_id = p_id;
737: l_parent_amount_remaining NUMBER:=0;
738:
739: CURSOR line_amt_sum_csr( p_id in NUMBER) IS

Line 749: FROM ozf_claims_all

745: l_child_line_total NUMBER:=0;
746:
747: CURSOR amount_sum_csr(p_id in NUMBER) IS
748: SELECT NVL(SUM(amount), 0)
749: FROM ozf_claims_all
750: WHERE split_from_claim_id = p_id;
751: l_child_amount_sum NUMBER:=0;
752:
753: CURSOR child_claim_id_csr(p_id in NUMBER) IS

Line 755: FROM ozf_claims_all

751: l_child_amount_sum NUMBER:=0;
752:
753: CURSOR child_claim_id_csr(p_id in NUMBER) IS
754: SELECT claim_id
755: FROM ozf_claims_all
756: WHERE split_from_claim_id = p_id;
757:
758: TYPE child_claim_id_Tbl_Type IS TABLE OF child_claim_id_csr%rowtype
759: INDEX BY BINARY_INTEGER;

Line 966: FROM ozf_claims_all

962: l_child_claim_tbl Child_Claim_tbl_type := p_child_claim_tbl;
963:
964: CURSOR parent_amount_rem_csr(p_id in NUMBER) IS
965: SELECT amount_remaining
966: FROM ozf_claims_all
967: WHERE claim_id = p_id;
968: l_parent_amount_remaining NUMBER:=0;
969:
970: CURSOR line_amount_sum_csr(p_id in number) IS

Line 1288: FROM ozf_claims_all

1284:
1285:
1286: CURSOR claim_class_csr(p_claim_id in number) IS
1287: SELECT claim_class
1288: FROM ozf_claims_all
1289: WHERE claim_id = p_claim_id;
1290:
1291: BEGIN
1292: -- Standard begin of API savepoint