APPS.OZF_FUND_UTILIZED_PUB dependencies on AMS_CAMPAIGN_SCHEDULES_VL

Line 112: FROM ams_campaign_schedules_vl

108: AND currency_code = p_curr_code;
109:
110: CURSOR c_valid_csch (p_activity_id IN NUMBER) IS
111: SELECT 1
112: FROM ams_campaign_schedules_vl
113: WHERE campaign_id = p_activity_id;
114:
115: CURSOR c_valid_cust_type (p_cust_type IN VARCHAR2) IS
116: SELECT 1

Line 299: FROM ams_campaign_schedules_vl

295: WHERE campaign_id = p_activity_id;
296:
297: CURSOR c_get_csch_currency (p_activity_id IN NUMBER) IS
298: SELECT transaction_currency_code F
299: FROM ams_campaign_schedules_vl
300: WHERE schedule_id = p_activity_id;
301:
302: CURSOR c_get_delv_currency (p_activity_id IN NUMBER) IS
303: SELECT transaction_currency_code