APPS.OZF_CLAIM_PVT dependencies on OZF_CLAIM_LINES_ALL

Line 2039: FROM ozf_claim_lines_all

2035: , activity_id
2036: , item_type
2037: , item_id
2038: , acctd_amount
2039: FROM ozf_claim_lines_all
2040: WHERE claim_line_id = cv_claim_line_id;
2041:
2042: -- Added for Bug#16301558
2043: CURSOR csr_customer_for_acc(cv_plan_id IN NUMBER) IS

Line 3832: FROM ozf_claim_lines_all

3828: , activity_id
3829: , item_type
3830: , item_id
3831: , acctd_amount
3832: FROM ozf_claim_lines_all
3833: WHERE claim_line_id = cv_claim_line_id;
3834:
3835: l_attribute VARCHAR2(30);
3836: L_ATTRIBUTE_PAD CONSTANT VARCHAR2(30) := 'OZF_RBS_RECEIPTS_PAD_ATTIBUTE';

Line 5511: from ozf_claim_lines_all

5507: l_claim_line_tbl OZF_Claim_Line_PVT.claim_line_tbl_type;
5508:
5509: CURSOR claim_line_id_csr(p_id in number)is
5510: select claim_line_id, object_version_number
5511: from ozf_claim_lines_all
5512: where claim_id = p_id;
5513:
5514: l_claim_line_id number;
5515: l_line_object_version_number number;

Line 6096: from ozf_claim_lines_all

6092: l_open_status_id number;
6093:
6094: CURSOR claim_currency_amount_sum_csr(p_id in NUMBER) IS
6095: select NVL(sum(claim_currency_amount), 0)
6096: from ozf_claim_lines_all
6097: where claim_id = p_id;
6098:
6099: CURSOR object_version_number_csr (p_id in number) is
6100: select object_version_number

Line 6172: FROM ozf_claim_lines_all

6168: l_old_write_off_flag varchar2(1);
6169:
6170: CURSOR claim_lines_csr(p_id in number)IS
6171: SELECT *
6172: FROM ozf_claim_lines_all
6173: WHERE claim_id = p_id;
6174:
6175: TYPE Claim_Lines_Type IS TABLE OF claim_lines_csr%rowtype
6176: INDEX BY BINARY_INTEGER;

Line 6302: ozf_claim_lines_all cln

6298: CURSOR claim_line_count_csr(p_claim_id in number
6299: ) IS
6300: SELECT count(cln.claim_id)
6301: FROM ozf_claims_all cla,
6302: ozf_claim_lines_all cln
6303: WHERE cla.claim_id = cln.claim_id
6304: AND cla.claim_id = p_claim_id;
6305:
6306: CURSOR csr_claim_line(cv_claim_line_id IN NUMBER) IS

Line 6313: FROM ozf_claim_lines_all

6309: , activity_id
6310: , item_type
6311: , item_id
6312: , acctd_amount
6313: FROM ozf_claim_lines_all
6314: WHERE claim_line_id = cv_claim_line_id;
6315:
6316: CURSOR claim_line_id_csr(p_id in number) IS
6317: SELECT claim_line_id, object_version_number

Line 6318: FROM ozf_claim_lines_all

6314: WHERE claim_line_id = cv_claim_line_id;
6315:
6316: CURSOR claim_line_id_csr(p_id in number) IS
6317: SELECT claim_line_id, object_version_number
6318: FROM ozf_claim_lines_all
6319: WHERE claim_id = p_id;
6320:
6321: /*CURSOR claim_hrd_invoice_csr(cv_claim_id in number) IS
6322: SELECT source_object_id

Line 6329: FROM ozf_claim_lines_all cln, ozf_claims_all cla

6325: */
6326:
6327: CURSOR claim_invoice_csr(cv_claim_id in number) IS
6328: SELECT count(*)
6329: FROM ozf_claim_lines_all cln, ozf_claims_all cla
6330: WHERE cla.claim_id = cln.claim_id
6331: AND cla.source_object_id = cln.source_object_id
6332: AND cla.claim_id = cv_claim_id
6333: GROUP BY cln.source_object_id;

Line 6342: FROM ozf_claim_lines_all

6338: WHERE qp_list_header_id = p_offer_id;
6339:
6340: CURSOR csr_claim_line_offr(p_id in number) is
6341: SELECT activity_id
6342: FROM ozf_claim_lines_all
6343: WHERE claim_id = p_id;
6344:
6345: --Bugfix : 10176541
6346: CURSOR exchange_rate_type_csr IS