APPS.HXC_TK_GRP_QUERY_CRITERIA_API dependencies on PER_PEOPLE_F

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 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