DBA Data[Home] [Help]

APPS.OZF_CLAIM_ACCRUAL_PVT dependencies on OZF_OFFER_PERFORMANCES

Line 4410: FROM ozf_offer_performances

4406: , end_date
4407: , requirement_type
4408: , estimated_value
4409: , uom_code
4410: FROM ozf_offer_performances
4411: WHERE required_flag = 'Y'
4412: AND product_attribute_context = 'ITEM'
4413: AND requirement_type IN ('AMOUNT', 'VOLUME')
4414: AND list_header_id = cv_offer_id;

Line 4902: FROM ozf_offer_performances

4898: AND organization_id = FND_PROFILE.VALUE('AMS_ITEM_ORGANIZATION_ID');
4899:
4900: CURSOR csr_offer_perf(cv_list_header_id IN NUMBER) IS
4901: SELECT 1
4902: FROM ozf_offer_performances
4903: WHERE list_header_id = cv_list_header_id;
4904:
4905: /*
4906: --Bug# 7319828 fixed by ateotia(+)

Line 5518: FROM ozf_offer_performances

5514: AND organization_id = FND_PROFILE.VALUE('AMS_ITEM_ORGANIZATION_ID');
5515:
5516: CURSOR csr_offer_perf(cv_list_header_id IN NUMBER) IS
5517: SELECT 1
5518: FROM ozf_offer_performances
5519: WHERE list_header_id = cv_list_header_id;
5520:
5521: l_pass_acctd_amount VARCHAR2(1) := 'F';
5522: