APPS.OZF_PROMOTIONAL_OFFERS_PVT dependencies on AMS_MEDIA_VL

Line 1409: FROM ams_media_vl

1405: IS
1406:
1407: CURSOR c_media_id(l_id NUMBER) IS
1408: SELECT 1
1409: FROM ams_media_vl
1410: WHERE media_type_code = 'DEAL'
1411: AND media_id = l_id;
1412:
1413: l_dummy NUMBER;