[Home] [Help]
1777: -- This cursor gets the date till which balances are found.
1778: --
1779: cursor c_bal_date(v_start_date date, v_end_date in date) is
1780: select max(pac.effective_date) + 1
1781: from pay_person_latest_balances plb,
1782: per_all_assignments_f asg,
1783: pay_assignment_actions paa,
1784: pay_payroll_actions pac
1785: where plb.person_id = l_epe.person_id