380: l_f_lump_catg hr_soft_coding_keyflex.segment3%TYPE;
381:
382: cursor csr_per_id is
383: select null 384: from per_all_people_f papf 385: where papf.person_id = p_per_or_asg_id and
386: papf.business_group_id = p_business_group_id and
387: p_effective_date between papf.effective_start_date and
388: papf.effective_end_date and
[Home] [Help]