757: l_f_lump_catg hr_soft_coding_keyflex.segment3%TYPE;
758:
759: cursor csr_per_id is
760: select null 761: from per_all_people_f papf 762: where papf.person_id = p_per_or_asg_id and
763: papf.business_group_id = p_business_group_id and
764: p_effective_date between papf.effective_start_date and
765: papf.effective_end_date and
[Home] [Help]