Line 64: from per_time_periods ptp, pay_payroll_actions ppa
60: l_period_start_date date;
61: begin
62: select ptp.start_date
63: into l_period_start_date 64: from per_time_periods ptp, pay_payroll_actions ppa 65: where ppa.payroll_action_id = p_user_payroll_action_id
66: and ppa.payroll_id = ptp.payroll_id
67: and p_user_effective_date between ptp.start_date and ptp.end_date;
68: -- see if balance was written in this period. If not it is expired