2015: LOOP
2016: FETCH csr_get_usr_col_id INTO l_usr_col_id;
2017: EXIT WHEN csr_get_usr_col_id%NOTFOUND;
2018:
2019: -- Delete pay_user_column_instances_f for this column_id
2020: hr_utility.set_location (l_proc_name, 30);
2021:
2022: DELETE pay_user_column_instances_f
2023: WHERE user_column_id = l_usr_col_id;
2018:
2019: -- Delete pay_user_column_instances_f for this column_id
2020: hr_utility.set_location (l_proc_name, 30);
2021:
2022: DELETE pay_user_column_instances_f
2023: WHERE user_column_id = l_usr_col_id;
2024:
2025: END LOOP;
2026: CLOSE csr_get_usr_col_id;