APPS.HR_EX_EMPLOYEE_API dependencies on PER_ALL_ASSIGNMENTS_F

Line 837: from per_all_assignments_f where person_id=p_person_id and period_of_service_id =p_pds_id

833:
834: select event_id,object_version_number
835: from per_events
836: where assignment_id in ( select distinct (assignment_id )
837: from per_all_assignments_f where person_id=p_person_id and period_of_service_id =p_pds_id
838: and assignment_type='E')
839: AND date_start > p_term_date;
840:
841: l_event number;

Line 2200: from per_all_assignments_f asg

2196: cursor csr_get_asgs_to_final_proc is
2197: select asg.assignment_id
2198: , asg.object_version_number
2199: , asg.primary_flag
2200: from per_all_assignments_f asg
2201: where asg.period_of_service_id = p_period_of_service_id
2202: and l_final_process_date between asg.effective_start_date
2203: and asg.effective_end_date
2204: and exists (

Line 2206: from per_all_assignments_f a1

2202: and l_final_process_date between asg.effective_start_date
2203: and asg.effective_end_date
2204: and exists (
2205: select 'X'
2206: from per_all_assignments_f a1
2207: where asg.assignment_id = a1.assignment_id
2208: and l_final_process_date+1 between a1.effective_start_date
2209: and a1.effective_end_date)
2210: order by asg.primary_flag;