275:
276: -- Bug 979903
277: cursor csr_get_legc_code is
278: select legislation_code
279: from per_business_groups_perf
280: where business_group_id = p_business_group_id;
281: --
282: --VS Bug:1402408. 11/14/00
283: cursor csr_payroll_exists is
821: and nvl(end_date_active,hr_api.g_eot);
822: --
823: cursor csr_valid_id_flex_num is
824: select null
825: from per_business_groups_perf pbg
826: ,pay_people_groups ppg
827: where ppg.people_group_id = p_people_group_id
828: and pbg.people_group_structure = to_char(ppg.id_flex_num)
829: and pbg.business_group_id = p_business_group_id;
3811: and nvl(end_date_active,hr_api.g_eot);
3812: --
3813: cursor csr_bg is
3814: select legislation_code
3815: from per_business_groups_perf
3816: where business_group_id = p_business_group_id;
3817: --
3818: cursor csr_pay_legislation_rules is
3819: select null