APPS.AMS_APPROVAL_PVT dependencies on OZF_OFFERS

Line 731: FROM ozf_offers OFF, qp_list_headers_vl qlh

727: ''priority_desc,
728: OFF.offer_code source_code, -- Bug 2873713
729: ''parent_source_code,
730: ''parent_name
731: FROM ozf_offers OFF, qp_list_headers_vl qlh
732: WHERE OFF.qp_list_header_id=qlh.list_header_id
733: AND qlh.list_header_id=p_activity_id;
734: /* code added by murali and the code from ravi end*/
735: ELSIF p_activity_type = 'EVEH' THEN

Line 2306: FROM ozf_offers

2302: l_percent NUMBER;
2303: l_offer_type VARCHAR2(30);
2304: CURSOR c_offer_type IS
2305: SELECT offer_type
2306: FROM ozf_offers
2307: WHERE qp_list_header_id = p_activity_id;
2308: BEGIN
2309: Fnd_Msg_Pub.initialize();
2310: -- Change for Offers Team for Bug 2861942

Line 3612: FROM ozf_offers OFF

3608: FROM ams_campaign_schedules_vl
3609: WHERE schedule_id = p_object_id;
3610: CURSOR c_offer IS
3611: SELECT transaction_currency_code
3612: FROM ozf_offers OFF
3613: WHERE OFF.qp_list_header_id = p_object_id;
3614: /* code added by murali code done by ravi end*/
3615: CURSOR c_eheader IS
3616: SELECT currency_code_tc

Line 7581: FROM ozf_offers

7577: l_custom_setup_id NUMBER;
7578:
7579: CURSOR c_offr(id IN NUMBER) IS
7580: SELECT custom_setup_id
7581: FROM ozf_offers
7582: WHERE qp_list_header_id = id;
7583: BEGIN
7584: Fnd_Msg_Pub.initialize();
7585: --