APPS.OZF_FUND_UTILIZED_PUB dependencies on AMS_CAMPAIGNS_VL

Line 58: FROM ams_campaigns_vl

54: WHERE fund_number = p_fund_num;
55:
56: CURSOR c_valid_campaign (p_activity_id IN NUMBER) IS
57: SELECT campaign_id
58: FROM ams_campaigns_vl
59: WHERE active_flag = 'Y'
60: AND show_campaign_flag = 'Y'
61: AND campaign_id = p_activity_id;
62:

Line 294: SELECT transaction_currency_code FROM ams_campaigns_vl

290: WHERE ol.line_id = p_order_line_id
291: AND ol.header_id = oh.header_id;
292:
293: CURSOR c_get_camp_currency (p_activity_id IN NUMBER) IS
294: SELECT transaction_currency_code FROM ams_campaigns_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