APPS.OZF_FUND_UTILIZED_PUB dependencies on AMS_EVENT_HEADERS_VL

Line 65: FROM ams_event_headers_vl event,

61: AND campaign_id = p_activity_id;
62:
63: CURSOR c_valid_event (p_activity_id IN NUMBER, p_approver_id IN NUMBER) IS
64: SELECT event.event_header_id
65: FROM ams_event_headers_vl event,
66: jtf_loc_hierarchies_vl loc,
67: ams_act_access_denorm acc
68: WHERE loc.location_type_code = 'COUNTRY'
69: AND event.active_flag='Y'

Line 308: SELECT currency_code_tc FROM ams_event_headers_vl

304: FROM ams_deliverables_vl
305: WHERE deliverable_id = p_activity_id;
306:
307: CURSOR c_get_eveh_currency (p_activity_id IN NUMBER) IS
308: SELECT currency_code_tc FROM ams_event_headers_vl
309: WHERE event_header_id = p_activity_id;
310:
311: CURSOR c_get_eveo_currency (p_activity_id IN NUMBER) IS
312: SELECT currency_code_tc FROM ams_event_offers_vl