I am currently trying to recode a part of package which extracts data from a source system and processes in the datawarehouse. Basically what the code does is:

**If it is a daily processing processing (p_run_type <> 1) and p_processing_lo cation is satisfied, distinct product ids will be inserted into v_table_name (which is basically a variable) from 3 different tables (using Union - to eliminate duplicate records)
...