434:
435: begin
436: select assignment_set_id
437: into ln_retro_asg_set_id
438: from hr_assignment_sets
439: where business_group_id = X_bg_id
440: and assignment_set_name like lv_retro_asg_set||'%';
441:
442: hr_utility.trace(' Retro Asg Set ID = '|| to_char(ln_retro_asg_set_id));
643:
644: begin
645: select assignment_set_id
646: into ln_retro_asg_set_id
647: from hr_assignment_sets
648: where business_group_id = X_bg_id
649: and assignment_set_name like lv_retro_asg_set||'%';
650:
651: hr_utility.trace(' Retro Asg Set ID = '|| to_char(ln_retro_asg_set_id));