APPS.AMS_LIST_PURGE_PVT dependencies on AMS_LIST_SRC_TYPES

Line 1417: FROM AMS_LIST_SRC_TYPES type

1413: WHERE status_code in ('AVAILABLE','LOCKED')
1414: AND trunc(creation_date) between trunc(l_start_date) AND trunc(l_end_date)
1415: AND list_type = p_list_type
1416: AND not exists (SELECT 1
1417: FROM AMS_LIST_SRC_TYPES type
1418: WHERE head.list_source_type = type.source_type_code
1419: AND nvl(type.remote_flag,'N') = 'Y') ;
1420: -- AND nvl(remote_gen_flag,'N') = 'N';
1421: else

Line 1428: FROM AMS_LIST_SRC_TYPES type

1424: SET request_id = l_conc_request_id,last_update_date = sysdate
1425: WHERE status_code in ('AVAILABLE','LOCKED')
1426: AND trunc(creation_date) between trunc(l_start_date) AND trunc(l_end_date)
1427: AND not exists (SELECT 1
1428: FROM AMS_LIST_SRC_TYPES type
1429: WHERE head.list_source_type = type.source_type_code
1430: AND nvl(type.remote_flag,'N') = 'Y') ;
1431: -- AND nvl(remote_gen_flag,'N') = 'N';
1432: end if;