APPS.PQH_TCT_WIZARD_PKG dependencies on PER_ALL_PEOPLE_F

Line 3810: from per_all_assignments_f ASG, per_all_people_f PPL, fnd_sessions ses

3806: --
3807: --
3808: Cursor csr_name is
3809: Select full_name
3810: from per_all_assignments_f ASG, per_all_people_f PPL, fnd_sessions ses
3811: Where asg.assignment_id = p_assignment_id
3812: AND asg.person_id = PPL.person_id
3813: AND SES.SESSION_ID = USERENV('sessionid')
3814: AND SES.EFFECTIVE_DATE BETWEEN ASG.EFFECTIVE_START_DATE AND ASG.EFFECTIVE_END_DATE

Line 3817: l_name per_all_people_f.full_name%type;

3813: AND SES.SESSION_ID = USERENV('sessionid')
3814: AND SES.EFFECTIVE_DATE BETWEEN ASG.EFFECTIVE_START_DATE AND ASG.EFFECTIVE_END_DATE
3815: AND SES.EFFECTIVE_DATE BETWEEN PPL.EFFECTIVE_START_DATE AND PPL.EFFECTIVE_END_DATE;
3816: --
3817: l_name per_all_people_f.full_name%type;
3818: l_proc varchar2(72) := 'return_person_name';
3819: --
3820: BEGIN
3821: --