APPS.AMS_APPROVAL_PVT dependencies on OZF_OFFERS

Line 767: FROM ozf_offers OFF, qp_list_headers_vl qlh

763: ''priority_desc,
764: OFF.offer_code source_code, -- Bug 2873713
765: ''parent_source_code,
766: ''parent_name
767: FROM ozf_offers OFF, qp_list_headers_vl qlh
768: WHERE OFF.qp_list_header_id=qlh.list_header_id
769: AND qlh.list_header_id=p_activity_id;
770: /* code added by murali and the code from ravi end*/
771: ELSIF p_activity_type = 'EVEH' THEN

Line 2342: FROM ozf_offers

2338: l_percent NUMBER;
2339: l_offer_type VARCHAR2(30);
2340: CURSOR c_offer_type IS
2341: SELECT offer_type
2342: FROM ozf_offers
2343: WHERE qp_list_header_id = p_activity_id;
2344: BEGIN
2345: Fnd_Msg_Pub.initialize();
2346: -- Change for Offers Team for Bug 2861942

Line 3699: FROM ozf_offers OFF

3695: FROM ams_campaign_schedules_vl
3696: WHERE schedule_id = p_object_id;
3697: CURSOR c_offer IS
3698: SELECT transaction_currency_code
3699: FROM ozf_offers OFF
3700: WHERE OFF.qp_list_header_id = p_object_id;
3701: /* code added by murali code done by ravi end*/
3702: CURSOR c_eheader IS
3703: SELECT currency_code_tc

Line 7672: FROM ozf_offers

7668: l_custom_setup_id NUMBER;
7669:
7670: CURSOR c_offr(id IN NUMBER) IS
7671: SELECT custom_setup_id
7672: FROM ozf_offers
7673: WHERE qp_list_header_id = id;
7674: BEGIN
7675: Fnd_Msg_Pub.initialize();
7676: --