eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_FUND_RECONCILE_PVT dependencies on AMS_CAMPAIGN_SCHEDULES_VL

Line 246: FROM ams_campaign_schedules_vl ozf

242: p_end_date IN DATE) IS
243: SELECT ozf.schedule_id object_id
244: ,ozf.transaction_currency_code object_curr
245: -- , ozf.end_date_time
246: FROM ams_campaign_schedules_vl ozf
247: WHERE NVL (ozf.end_date_time, p_grace_date) <= p_grace_date
248: -- changed to archived 08/20/2001 mpande
249: --AND ozf.status_code IN ('CLOSED','COMPLETED','CANCELLED','ARCHIVED') -- inactive ;
250: AND ozf.status_code IN (p_status)

Line 2204: FROM ams_campaign_schedules_vl

2200: WHERE campaign_id = p_object_id;
2201:
2202: CURSOR c_campaign_schl(p_object_id IN NUMBER) IS
2203: SELECT status_code
2204: FROM ams_campaign_schedules_vl
2205: WHERE schedule_id = p_object_id;
2206:
2207: CURSOR c_eheader(p_object_id IN NUMBER) IS
2208: SELECT system_status_code