DBA Data[Home] [Help]

APPS.PQH_UTILITY dependencies on PER_ALL_ASSIGNMENTS_F

Line 988: from per_all_assignments_f asg , per_all_people_f ppl,fnd_sessions ses

984: --
985: Cursor assignment_name is
986: Select substr(ppl.full_name||'('||hr_general.decode_lookup('PQH_GEN_LOV','EMP_
987: NUM')||'='||ppl.employee_number||')',1,240)
988: from per_all_assignments_f asg , per_all_people_f ppl,fnd_sessions ses
989: where asg.assignment_id = p_assignment_id
990: and asg.person_id = ppl.person_id
991: and ses.session_id = userenv('sessionid')
992: and ses.effective_date between ppl.effective_start_date and ppl.effective_end_date