671: and usr.employee_id=linkppf.person_id
672: and ppf.party_id = linkppf.party_id
673: and ppf.person_id = paf.person_id
674: and paf.assignment_id= p_assignment_id
675: and usr.user_id = fnd_global.user_id;
676: --
677: begin
678: --
679: hr_utility.set_location(' Entering: '|| l_proc, 10);
689: END IF;
690: CLOSE csr_applicant_userid;
691: --
692: hr_utility.set_location('l_user_id: '||l_user_id,20);
693: hr_utility.set_location('g_user_id: '||fnd_global.user_id,30);
694: --
695: if l_user_id=fnd_global.user_id then
696: l_manager_terminates:='N';
697: else
691: --
692: hr_utility.set_location('l_user_id: '||l_user_id,20);
693: hr_utility.set_location('g_user_id: '||fnd_global.user_id,30);
694: --
695: if l_user_id=fnd_global.user_id then
696: l_manager_terminates:='N';
697: else
698: l_manager_terminates:='Y';
699: end if;