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 243: FROM ams_campaign_schedules_vl ozf

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

Line 2156: FROM ams_campaign_schedules_vl

2152: WHERE campaign_id = p_object_id;
2153:
2154: CURSOR c_campaign_schl(p_object_id IN NUMBER) IS
2155: SELECT status_code
2156: FROM ams_campaign_schedules_vl
2157: WHERE schedule_id = p_object_id;
2158:
2159: CURSOR c_eheader(p_object_id IN NUMBER) IS
2160: SELECT system_status_code