DBA Data[Home] [Help]

APPS.OZF_CLAIM_PVT dependencies on OZF_CLAIM_LINES_ALL

Line 4643: from ozf_claim_lines_all

4639: l_claim_line_tbl OZF_Claim_Line_PVT.claim_line_tbl_type;
4640:
4641: CURSOR claim_line_id_csr(p_id in number)is
4642: select claim_line_id, object_version_number
4643: from ozf_claim_lines_all
4644: where claim_id = p_id;
4645:
4646: l_claim_line_id number;
4647: l_line_object_version_number number;

Line 5218: from ozf_claim_lines_all

5214: l_open_status_id number;
5215:
5216: CURSOR claim_currency_amount_sum_csr(p_id in NUMBER) IS
5217: select NVL(sum(claim_currency_amount), 0)
5218: from ozf_claim_lines_all
5219: where claim_id = p_id;
5220:
5221: CURSOR object_version_number_csr (p_id in number) is
5222: select object_version_number

Line 5282: FROM ozf_claim_lines_all

5278: l_old_write_off_flag varchar2(1);
5279:
5280: CURSOR claim_lines_csr(p_id in number)IS
5281: SELECT *
5282: FROM ozf_claim_lines_all
5283: WHERE claim_id = p_id;
5284:
5285: TYPE Claim_Lines_Type IS TABLE OF claim_lines_csr%rowtype
5286: INDEX BY BINARY_INTEGER;