APPS.OZF_AR_INTERFACE_PVT dependencies on OZF_CLAIM_LINES

Line 990: FROM ozf_claim_lines

986: RETURN NUMBER IS
987:
988: CURSOR csr_memo_line(cv_claim_line_id IN NUMBER) IS
989: SELECT item_id
990: FROM ozf_claim_lines
991: WHERE claim_line_id = cv_claim_line_id
992: AND item_type = 'MEMO_LINE';--11.5.10 Enhancements.
993: l_memo_line_id NUMBER;
994:

Line 1122: FROM ozf_claim_lines

1118: , rate
1119: , item_type
1120: , item_description
1121: , source_object_class -- added for bug 4716020
1122: FROM ozf_claim_lines
1123: WHERE claim_line_id = cv_claim_line_id;
1124:
1125: l_batch_source_id NUMBER;
1126: l_billback_trx_type_id NUMBER;

Line 1153: FROM ozf_offers offer, ozf_claim_lines_all line

1149: AND organization_id = FND_PROFILE.VALUE('AMS_ITEM_ORGANIZATION_ID');
1150:
1151: CURSOR csr_offer_name(cv_claim_line_id IN NUMBER)IS
1152: SELECT SUBSTR(offer_code,1,50)
1153: FROM ozf_offers offer, ozf_claim_lines_all line
1154: WHERE qp_list_header_id = line.offer_id
1155: AND claim_line_id = cv_claim_line_id;
1156:
1157: -- Introduced for Bug4348163

Line 2010: FROM ozf_claim_lines cll

2006: /*
2007: CURSOR grouped_claim_line_csr IS
2008: SELECT SUM(NVL(cll.claim_currency_amount,0)),
2009: NVL(cll.claim_currency_amount,0)
2010: FROM ozf_claim_lines cll
2011: WHERE cll.claim_id = p_claim_id;
2012: GROUP BY Get_Memo_Line_Id(cll.claim_id);
2013: */
2014: --12.1 Price Protection Enhancement

Line 2022: FROM ozf_claim_lines cll

2018: , cll.tax_code
2019: , Get_Memo_Line_Id(cll.claim_line_id)
2020: , cll.earnings_associated_flag
2021: , cll.source_object_class
2022: FROM ozf_claim_lines cll
2023: WHERE cll.claim_id = p_claim_id;
2024:
2025: l_memo_line_id NUMBER;
2026: l_grpd_claim_curr_amt NUMBER;

Line 2106: ,p_source_table => 'OZF_CLAIM_LINES_ALL'

2102: ,x_return_status => l_return_status
2103: ,x_msg_data => x_msg_data
2104: ,x_msg_count => x_msg_count
2105: ,p_source_id => l_claim_line_id
2106: ,p_source_table => 'OZF_CLAIM_LINES_ALL'
2107: ,p_account_type => 'REC_CLEARING'
2108: ,x_cc_id_tbl => l_cc_id_tbl
2109: );
2110: IF x_return_status = FND_API.G_RET_STS_ERROR THEN