APPS.OZF_OFFER_PUB dependencies on OZF_OFFERS

Line 54: FROM ozf_offers

50: l_qualifiers_tbl_out qp_qualifier_rules_pub.qualifiers_tbl_type;
51:
52: CURSOR c_offer_info(l_qp_list_header_id NUMBER) IS
53: SELECT offer_id, offer_type, custom_setup_id, offer_code, tier_level, object_version_number
54: FROM ozf_offers
55: WHERE qp_list_header_id = l_qp_list_header_id;
56:
57: CURSOR c_act_budget_obj_ver(l_act_budg_id NUMBER) IS
58: SELECT object_version_number

Line 1205: FROM ozf_offers

1201: WHERE activity_budget_id = l_act_budg_id;
1202:
1203: CURSOR c_offer_info(l_qp_list_header_id NUMBER) IS
1204: SELECT offer_id, offer_type, custom_setup_id, offer_code, object_version_number
1205: FROM ozf_offers
1206: WHERE qp_list_header_id = l_qp_list_header_id;
1207:
1208: l_api_version CONSTANT NUMBER := 1.0;
1209: l_api_name CONSTANT VARCHAR2(30) := 'process_vo';