APPS.OZF_ACTBUDGETRULES_PVT dependencies on OZF_OFFERS

Line 43: FROM ozf_offers

39: WHERE schedule_id = p_used_by_id;
40: -- 03/28/2002 added for Offer
41: CURSOR c_get_off_activity_id (p_used_by_id IN NUMBER) IS
42: SELECT activity_media_id
43: FROM ozf_offers
44: WHERE qp_list_header_id = p_used_by_id;
45:
46: CURSOR c_get_cat_activity (p_category_id IN NUMBER, p_activity_id IN NUMBER) IS
47: SELECT 'X'

Line 544: FROM ozf_offers

540: WHERE fund_id = p_object_id;
541:
542: CURSOR c_offer (p_object_id IN NUMBER) IS
543: SELECT custom_setup_id, owner_id
544: FROM ozf_offers
545: WHERE qp_list_header_id = p_object_id;
546:
547: l_custom_setup_id NUMBER;
548: l_flag VARCHAR2 (1);

Line 759: FROM ozf_offers

755:
756: -- this amount column would change
757: CURSOR c_offer IS
758: SELECT budget_amount_tc, status_code
759: FROM ozf_offers
760: WHERE qp_list_header_id = p_object_id;
761:
762: l_amount NUMBER;
763: l_existing_amount NUMBER;