If your partitions are named using something based off of a date or sequence, then you can target your "active" partition as long as the partition name follows a standard naming convention. For example, if you use "some_table_part_MMYY" as the name, then the current month/current partition is ID'd by getting the MMYY part out of sysdate.