APPS.HXC_TK_GRP_QUERY_CRITERIA_API dependencies on PER_ASSIGNMENTS_F

Line 570: FROM per_assignments_f asg

566: CURSOR csr_chk_assignment_id IS
567: SELECT 'x'
568: FROM dual
569: WHERE EXISTS ( select 'x'
570: FROM per_assignments_f asg
571: WHERE asg.assignment_id = p_criteria_id );
572: -- GAZ - anymore specific ????
573:
574: CURSOR csr_chk_person_id IS

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