APPS.OZF_FUND_UTILIZED_PUB dependencies on OZF_OFFERS

Line 83: FROM ozf_offers

79: AND b.deliverable_id = p_activity_id;
80:
81: CURSOR c_valid_offer (p_activity_id IN NUMBER) IS
82: SELECT qp_list_header_id
83: FROM ozf_offers
84: WHERE qp_list_header_id = p_activity_id;
85:
86: CURSOR c_valid_csch (p_activity_id IN NUMBER) IS
87: SELECT 1

Line 120: FROM ams_media_channels_vl med, ozf_offers off

116: AND hzs.site_use_id = p_cust_id;
117:
118: CURSOR c_valid_scantype_id (p_activity_id IN NUMBER, p_scan_type_id IN NUMBER) IS
119: SELECT 1
120: FROM ams_media_channels_vl med, ozf_offers off
121: WHERE med.media_id = off.activity_media_id(+)
122: AND qp_list_header_id = p_activity_id
123: AND channel_id = p_scan_type_id;
124: