30:
31: /* this selects the effective date for the payroll_run*/
32: select ppa.effective_date
33: into l_effective_date 34: from pay_payroll_actions ppa 35: where ppa.payroll_action_id = l_id;
36:
37: /* Selects to get the relevant id's */
38: select user_table_id