APPS.OZF_SCHEDULE_DENORM_PVT dependencies on AMS_ACT_LISTS

Line 228: ams_act_lists al

224: sysdate,FND_GLOBAL.user_id,sysdate,FND_GLOBAL.user_id,FND_GLOBAL.conc_login_id
225: FROM
226: ams_campaign_schedules_b s,
227: ams_act_products ap,
228: ams_act_lists al
229: WHERE
230: s.campaign_id = i.campaign_id AND
231: ap.act_product_used_by_id(+) = s.schedule_id AND
232: ap.arc_act_product_used_by(+) = 'CSCH' and

Line 775: ams_act_lists al

771: ap.level_type_code item_type, al.list_header_id,sysdate,null,sysdate,null,null,sysdate
772: FROM
773: ams_campaign_schedules_b s,
774: ams_act_products ap,
775: ams_act_lists al
776: WHERE
777: s.campaign_id = i.campaign_id AND
778: s.creation_date > l_latest_comp_date and
779: ap.act_product_used_by_id(+) = s.schedule_id AND