APPS.OZF_SCHEDULE_DENORM_PVT dependencies on AMS_LIST_HEADERS_ALL

Line 382: FROM ozf_activity_hl_denorm a,ams_list_headers_all lh

378: AND am.item is not null;
379:
380: CURSOR c_changed_list_headers(l_latest_comp_date DATE) IS
381: SELECT DISTINCT a.schedule_id
382: FROM ozf_activity_hl_denorm a,ams_list_headers_all lh
383: WHERE a.list_header_id is not null
384: AND lh.list_header_id = a.list_header_id
385: AND lh.last_update_date > l_latest_comp_date;
386: