APPS.OZF_ACTBUDGETRULES_PVT dependencies on OZF_OFFERS

Line 46: FROM ozf_offers

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

Line 550: FROM ozf_offers

546: WHERE fund_id = p_object_id;
547:
548: CURSOR c_offer (p_object_id IN NUMBER) IS
549: SELECT custom_setup_id, owner_id
550: FROM ozf_offers
551: WHERE qp_list_header_id = p_object_id;
552:
553: l_custom_setup_id NUMBER;
554: l_flag VARCHAR2 (1);

Line 765: FROM ozf_offers

761:
762: -- this amount column would change
763: CURSOR c_offer IS
764: SELECT budget_amount_tc, status_code
765: FROM ozf_offers
766: WHERE qp_list_header_id = p_object_id;
767:
768: l_amount NUMBER;
769: l_existing_amount NUMBER;