DBA Data[Home] [Help]

APPS.PQH_TCT_WIZARD_PKG dependencies on PER_ALL_ASSIGNMENTS_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