APPS.OZF_CLAIM_GRP dependencies on OZF_CLAIMS_ALL

Line 1907: FROM ozf_claims_all

1903:
1904: -- get Count for given claim_id
1905: CURSOR get_claim_count_csr (p_claim_id in number) IS
1906: SELECT count(*)
1907: FROM ozf_claims_all
1908: WHERE root_claim_id = p_claim_id;
1909:
1910: -- get existing claim details.
1911: CURSOR get_claim_detail_csr (p_claim_id in number) IS

Line 1915: FROM ozf_claims_all

1911: CURSOR get_claim_detail_csr (p_claim_id in number) IS
1912: SELECT status_code,amount,receipt_number,claim_class,
1913: amount_remaining+amount_settled amount_remaining,
1914: source_object_id
1915: FROM ozf_claims_all
1916: WHERE claim_id = p_claim_id;
1917:
1918: -- Added for Bug4872736
1919: CURSOR get_split_claim_detail_csr (p_claim_id in number) IS

Line 1923: FROM ozf_claims_all

1919: CURSOR get_split_claim_detail_csr (p_claim_id in number) IS
1920: SELECT claim_class,
1921: sum(amount_remaining+amount_settled) amount_remaining,
1922: source_object_id
1923: FROM ozf_claims_all
1924: WHERE root_claim_id = p_claim_id
1925: GROUP BY claim_class, source_object_id;
1926:
1927: -- get split claim details.

Line 1939: FROM ozf_claims_all

1935: amount,
1936: amount_adjusted,
1937: amount_remaining,
1938: amount_settled
1939: FROM ozf_claims_all
1940: WHERE root_claim_id = p_claim_id
1941: ORDER BY claim_id;
1942:
1943: -- get Claim_Class for claim_id

Line 1946: FROM ozf_claims_all

1942:
1943: -- get Claim_Class for claim_id
1944: CURSOR get_claim_class_csr(p_claim_id IN NUMBER) IS
1945: SELECT claim_class,reason_code_id,object_version_number,claim_type_id
1946: FROM ozf_claims_all
1947: WHERE claim_id = p_claim_id;
1948:
1949: -- get Newly created split claim_id and claim_number
1950: CURSOR get_split_claim_ids_csr(p_claim_id IN NUMBER) IS

Line 1952: FROM ozf_claims_all

1948:
1949: -- get Newly created split claim_id and claim_number
1950: CURSOR get_split_claim_ids_csr(p_claim_id IN NUMBER) IS
1951: SELECT claim_id,claim_number
1952: FROM ozf_claims_all
1953: WHERE root_claim_id = p_claim_id
1954: AND claim_id = (Select max(claim_id)
1955: from ozf_claims_all
1956: where root_claim_id = p_claim_id)

Line 1955: from ozf_claims_all

1951: SELECT claim_id,claim_number
1952: FROM ozf_claims_all
1953: WHERE root_claim_id = p_claim_id
1954: AND claim_id = (Select max(claim_id)
1955: from ozf_claims_all
1956: where root_claim_id = p_claim_id)
1957: AND trunc(creation_date) = trunc(sysdate);
1958:
1959: -- get Amount Due on Invoice

Line 1962: FROM ar_payment_schedules a, ozf_claims_all b

1958:
1959: -- get Amount Due on Invoice
1960: CURSOR get_invoice_amount_due_csr (p_claim_id in NUMBER) IS
1961: SELECT amount_due_original
1962: FROM ar_payment_schedules a, ozf_claims_all b
1963: WHERE customer_trx_id = b.source_object_id
1964: AND b.claim_id = p_claim_id;
1965:
1966: -- [BEGIN OF BUG 3775972 FIXING]

Line 2720: FROM ozf_claims_all

2716: SELECT object_version_number,
2717: reason_code_id,
2718: claim_id,
2719: claim_number
2720: FROM ozf_claims_all
2721: WHERE claim_id = p_id;
2722:
2723: -- get claim_reason_name
2724: CURSOR claim_name_csr(p_reason_code_id in number) IS

Line 2732: FROM ozf_claims_all

2728:
2729: -- get object_version_number
2730: CURSOR claim_object_version_csr(p_id in number) IS
2731: SELECT object_version_number
2732: FROM ozf_claims_all
2733: WHERE claim_id = p_id;
2734:
2735: -- get minimum required data
2736: CURSOR claim_min_req_data_csr(p_id in number) IS

Line 2738: FROM ozf_claims_all

2734:
2735: -- get minimum required data
2736: CURSOR claim_min_req_data_csr(p_id in number) IS
2737: SELECT claim_number
2738: FROM ozf_claims_all
2739: WHERE claim_id = p_id;
2740:
2741: -- get claim_id, claim_number incase it is not passed by AR.
2742: CURSOR get_claim_identifier_csr(p_source_object_id in number) IS

Line 2744: FROM ozf_claims_all

2740:
2741: -- get claim_id, claim_number incase it is not passed by AR.
2742: CURSOR get_claim_identifier_csr(p_source_object_id in number) IS
2743: SELECT root_claim_id,claim_number
2744: FROM ozf_claims_all
2745: WHERE source_object_id = p_source_object_id
2746: AND root_claim_id = claim_id;
2747: --AND status_code <> 'CLOSED';
2748: