APPS.OZF_AR_INTERFACE_PVT dependencies on OZF_OFFERS

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