APPS.OZF_AR_INTERFACE_PVT dependencies on OZF_CLAIM_LINES

Line 994: FROM ozf_claim_lines

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

Line 1126: FROM ozf_claim_lines

1122: , rate
1123: , item_type
1124: , item_description
1125: , source_object_class -- added for bug 4716020
1126: FROM ozf_claim_lines
1127: WHERE claim_line_id = cv_claim_line_id;
1128:
1129: l_batch_source_id NUMBER;
1130: l_billback_trx_type_id NUMBER;

Line 1157: FROM ozf_offers offer, ozf_claim_lines_all line

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

Line 2019: FROM ozf_claim_lines cll

2015: /*
2016: CURSOR grouped_claim_line_csr IS
2017: SELECT SUM(NVL(cll.claim_currency_amount,0)),
2018: NVL(cll.claim_currency_amount,0)
2019: FROM ozf_claim_lines cll
2020: WHERE cll.claim_id = p_claim_id;
2021: GROUP BY Get_Memo_Line_Id(cll.claim_id);
2022: */
2023: --12.1 Price Protection Enhancement

Line 2031: FROM ozf_claim_lines cll

2027: , cll.tax_code
2028: , Get_Memo_Line_Id(cll.claim_line_id)
2029: , cll.earnings_associated_flag
2030: , cll.source_object_class
2031: FROM ozf_claim_lines cll
2032: WHERE cll.claim_id = p_claim_id;
2033:
2034: l_memo_line_id NUMBER;
2035: l_grpd_claim_curr_amt NUMBER;

Line 2115: ,p_source_table => 'OZF_CLAIM_LINES_ALL'

2111: ,x_return_status => l_return_status
2112: ,x_msg_data => x_msg_data
2113: ,x_msg_count => x_msg_count
2114: ,p_source_id => l_claim_line_id
2115: ,p_source_table => 'OZF_CLAIM_LINES_ALL'
2116: ,p_account_type => 'REC_CLEARING'
2117: ,x_cc_id_tbl => l_cc_id_tbl
2118: );
2119: IF x_return_status = FND_API.G_RET_STS_ERROR THEN