679: CURSOR csr_rpt_data(pactid number) IS
680: select ppa.start_date,
681: ppa.effective_date,
682: bg.name
683: from per_business_groups bg,
684: pay_payroll_actions ppa
685: where ppa.payroll_action_id = pactid
686: and ppa.business_group_id = bg.business_group_id;
687:
687:
688: l_payroll_action_id number;
689: l_start_date date;
690: l_end_date date;
691: l_bg_name per_business_groups.name%TYPE;
692:
693: BEGIN
694: hr_utility.set_location('Entering : '||l_proc_name, 10);
695: