APPS.OZF_SPLIT_CLAIM_PVT dependencies on OZF_CLAIMS_ALL

Line 76: FROM OZF_CLAIMS_ALL

72: l_split_status_type VARCHAR2(30);
73:
74: CURSOR parent_claim_csr(p_id in number) IS
75: SELECT *
76: FROM OZF_CLAIMS_ALL
77: WHERE claim_id = p_id;
78: l_parent_claim parent_claim_csr%ROWTYPE;
79:
80: -- [BEGIN OF BUG 3473501 FIXING]

Line 396: FROM ozf_claims_all

392: l_object_version_number NUMBER;
393:
394: CURSOR version_csr (p_id in number) IS
395: SELECT object_version_number
396: FROM ozf_claims_all
397: WHERE claim_id = p_id;
398:
399: CURSOR status_code_csr(p_id in number) IS
400: SELECT status_code

Line 401: FROM ozf_claims_all

397: WHERE claim_id = p_id;
398:
399: CURSOR status_code_csr(p_id in number) IS
400: SELECT status_code
401: FROM ozf_claims_all
402: WHERE claim_id = p_id;
403: l_status_code VARCHAR(30);
404:
405: CURSOR line_amount_sum_csr(p_id in number) IS

Line 577: FROM ozf_claims_all

573: l_line_obj_num NUMBER;
574:
575: CURSOR claim_info_csr (p_id in number) IS
576: SELECT object_version_number, status_code, amount_adjusted, amount_remaining, currency_code, reason_code_id
577: FROM ozf_claims_all
578: WHERE claim_id = p_id;
579: l_object_version_number NUMBER;
580: l_status_code varchar2(30);
581: l_amount_adjusted number;

Line 728: FROM ozf_claims_all

724: l_msg_count NUMBER;
725:
726: CURSOR amount_csr(p_id in NUMBER) IS
727: SELECT amount_remaining
728: FROM ozf_claims_all
729: WHERE claim_id = p_id;
730: l_parent_amount_remaining NUMBER:=0;
731:
732: CURSOR line_amt_sum_csr( p_id in NUMBER) IS

Line 742: FROM ozf_claims_all

738: l_child_line_total NUMBER:=0;
739:
740: CURSOR amount_sum_csr(p_id in NUMBER) IS
741: SELECT NVL(SUM(amount), 0)
742: FROM ozf_claims_all
743: WHERE split_from_claim_id = p_id;
744: l_child_amount_sum NUMBER:=0;
745:
746: CURSOR child_claim_id_csr(p_id in NUMBER) IS

Line 748: FROM ozf_claims_all

744: l_child_amount_sum NUMBER:=0;
745:
746: CURSOR child_claim_id_csr(p_id in NUMBER) IS
747: SELECT claim_id
748: FROM ozf_claims_all
749: WHERE split_from_claim_id = p_id;
750:
751: TYPE child_claim_id_Tbl_Type IS TABLE OF child_claim_id_csr%rowtype
752: INDEX BY BINARY_INTEGER;

Line 919: FROM ozf_claims_all

915: l_child_claim_tbl Child_Claim_tbl_type := p_child_claim_tbl;
916:
917: CURSOR parent_amount_rem_csr(p_id in NUMBER) IS
918: SELECT amount_remaining
919: FROM ozf_claims_all
920: WHERE claim_id = p_id;
921: l_parent_amount_remaining NUMBER:=0;
922:
923: CURSOR line_amount_sum_csr(p_id in number) IS

Line 1237: FROM ozf_claims_all

1233:
1234:
1235: CURSOR claim_class_csr(p_claim_id in number) IS
1236: SELECT claim_class
1237: FROM ozf_claims_all
1238: WHERE claim_id = p_claim_id;
1239:
1240: BEGIN
1241: -- Standard begin of API savepoint