DBA Data[Home] [Help]

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