APPS.OZF_CLAIM_GRP dependencies on OZF_CLAIMS_ALL

Line 1891: FROM ozf_claims_all

1887:
1888: -- get Count for given claim_id
1889: CURSOR get_claim_count_csr (p_claim_id in number) IS
1890: SELECT count(*)
1891: FROM ozf_claims_all
1892: WHERE root_claim_id = p_claim_id;
1893:
1894: -- get existing claim details.
1895: CURSOR get_claim_detail_csr (p_claim_id in number) IS

Line 1899: FROM ozf_claims_all

1895: CURSOR get_claim_detail_csr (p_claim_id in number) IS
1896: SELECT status_code,amount,receipt_number,claim_class,
1897: amount_remaining+amount_settled amount_remaining,
1898: source_object_id
1899: FROM ozf_claims_all
1900: WHERE claim_id = p_claim_id;
1901:
1902: -- Added for Bug4872736
1903: CURSOR get_split_claim_detail_csr (p_claim_id in number) IS

Line 1907: FROM ozf_claims_all

1903: CURSOR get_split_claim_detail_csr (p_claim_id in number) IS
1904: SELECT claim_class,
1905: sum(amount_remaining+amount_settled) amount_remaining,
1906: source_object_id
1907: FROM ozf_claims_all
1908: WHERE root_claim_id = p_claim_id
1909: GROUP BY claim_class, source_object_id;
1910:
1911: -- get split claim details.

Line 1923: FROM ozf_claims_all

1919: amount,
1920: amount_adjusted,
1921: amount_remaining,
1922: amount_settled
1923: FROM ozf_claims_all
1924: WHERE root_claim_id = p_claim_id
1925: ORDER BY claim_id;
1926:
1927: -- get Claim_Class for claim_id

Line 1930: FROM ozf_claims_all

1926:
1927: -- get Claim_Class for claim_id
1928: CURSOR get_claim_class_csr(p_claim_id IN NUMBER) IS
1929: SELECT claim_class,reason_code_id,object_version_number,claim_type_id
1930: FROM ozf_claims_all
1931: WHERE claim_id = p_claim_id;
1932:
1933: -- get Newly created split claim_id and claim_number
1934: CURSOR get_split_claim_ids_csr(p_claim_id IN NUMBER) IS

Line 1936: FROM ozf_claims_all

1932:
1933: -- get Newly created split claim_id and claim_number
1934: CURSOR get_split_claim_ids_csr(p_claim_id IN NUMBER) IS
1935: SELECT claim_id,claim_number
1936: FROM ozf_claims_all
1937: WHERE root_claim_id = p_claim_id
1938: AND claim_id = (Select max(claim_id)
1939: from ozf_claims_all
1940: where root_claim_id = p_claim_id)

Line 1939: from ozf_claims_all

1935: SELECT claim_id,claim_number
1936: FROM ozf_claims_all
1937: WHERE root_claim_id = p_claim_id
1938: AND claim_id = (Select max(claim_id)
1939: from ozf_claims_all
1940: where root_claim_id = p_claim_id)
1941: AND trunc(creation_date) = trunc(sysdate);
1942:
1943: -- get Amount Due on Invoice

Line 1946: FROM ar_payment_schedules a, ozf_claims_all b

1942:
1943: -- get Amount Due on Invoice
1944: CURSOR get_invoice_amount_due_csr (p_claim_id in NUMBER) IS
1945: SELECT amount_due_original
1946: FROM ar_payment_schedules a, ozf_claims_all b
1947: WHERE customer_trx_id = b.source_object_id
1948: AND b.claim_id = p_claim_id;
1949:
1950: -- [BEGIN OF BUG 3775972 FIXING]

Line 2696: FROM ozf_claims_all

2692: SELECT object_version_number,
2693: reason_code_id,
2694: claim_id,
2695: claim_number
2696: FROM ozf_claims_all
2697: WHERE claim_id = p_id;
2698:
2699: -- get claim_reason_name
2700: CURSOR claim_name_csr(p_reason_code_id in number) IS

Line 2708: FROM ozf_claims_all

2704:
2705: -- get object_version_number
2706: CURSOR claim_object_version_csr(p_id in number) IS
2707: SELECT object_version_number
2708: FROM ozf_claims_all
2709: WHERE claim_id = p_id;
2710:
2711: -- get minimum required data
2712: CURSOR claim_min_req_data_csr(p_id in number) IS

Line 2714: FROM ozf_claims_all

2710:
2711: -- get minimum required data
2712: CURSOR claim_min_req_data_csr(p_id in number) IS
2713: SELECT claim_number
2714: FROM ozf_claims_all
2715: WHERE claim_id = p_id;
2716:
2717: -- get claim_id, claim_number incase it is not passed by AR.
2718: CURSOR get_claim_identifier_csr(p_source_object_id in number) IS

Line 2720: FROM ozf_claims_all

2716:
2717: -- get claim_id, claim_number incase it is not passed by AR.
2718: CURSOR get_claim_identifier_csr(p_source_object_id in number) IS
2719: SELECT root_claim_id,claim_number
2720: FROM ozf_claims_all
2721: WHERE source_object_id = p_source_object_id
2722: AND root_claim_id = claim_id;
2723: --AND status_code <> 'CLOSED';
2724: