APPS.PQH_TCT_WIZARD_PKG dependencies on PER_ALL_PEOPLE_F

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

3827: --
3828: --
3829: Cursor csr_name is
3830: Select full_name
3831: from per_all_assignments_f ASG, per_all_people_f PPL, fnd_sessions ses
3832: Where asg.assignment_id = p_assignment_id
3833: AND asg.person_id = PPL.person_id
3834: AND SES.SESSION_ID = USERENV('sessionid')
3835: AND SES.EFFECTIVE_DATE BETWEEN ASG.EFFECTIVE_START_DATE AND ASG.EFFECTIVE_END_DATE

Line 3838: l_name per_all_people_f.full_name%type;

3834: AND SES.SESSION_ID = USERENV('sessionid')
3835: AND SES.EFFECTIVE_DATE BETWEEN ASG.EFFECTIVE_START_DATE AND ASG.EFFECTIVE_END_DATE
3836: AND SES.EFFECTIVE_DATE BETWEEN PPL.EFFECTIVE_START_DATE AND PPL.EFFECTIVE_END_DATE;
3837: --
3838: l_name per_all_people_f.full_name%type;
3839: l_proc varchar2(72) := 'return_person_name';
3840: --
3841: BEGIN
3842: --