APPS.HXC_TK_GRP_QUERY_CRITERIA_API dependencies on PER_PEOPLE

Line 578: FROM per_people_f p

574: CURSOR csr_chk_person_id IS
575: SELECT 'x'
576: FROM dual
577: WHERE EXISTS ( select 'x'
578: FROM per_people_f p
579: WHERE p.person_id = p_criteria_id );
580: -- GAZ - anymore specific ????
581:
582: BEGIN

Line 722: FROM per_people p

718: WHERE asg.assignment_id = p_criteria_id;
719:
720: CURSOR csr_get_employee_number IS
721: SELECT p.employee_number
722: FROM per_people p
723: WHERE p.person_id = p_criteria_id;
724:
725: CURSOR csr_get_full_name IS
726: SELECT ppf.full_name

Line 727: FROM per_assignments_f asg,fnd_sessions ss,per_people_f ppf

723: WHERE p.person_id = p_criteria_id;
724:
725: CURSOR csr_get_full_name IS
726: SELECT ppf.full_name
727: FROM per_assignments_f asg,fnd_sessions ss,per_people_f ppf
728: WHERE asg.effective_start_date <= ss.effective_date
729: AND asg.effective_end_date >= ss.effective_date
730: AND ss.session_id = USERENV ('sessionid')
731: AND ppf.effective_start_date <= ss.effective_date

Line 740: FROM per_people p

736:
737:
738: CURSOR csr_get_person_full_name IS
739: SELECT p.full_name
740: FROM per_people p
741: WHERE p.person_id = p_criteria_id;
742:
743: BEGIN
744: