eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_EX_EMPLOYEE_API dependencies on PER_ALL_ASSIGNMENTS_F

Line 1909: from per_all_assignments_f asg

1905: cursor csr_get_asgs_to_final_proc is
1906: select asg.assignment_id
1907: , asg.object_version_number
1908: , asg.primary_flag
1909: from per_all_assignments_f asg
1910: where asg.period_of_service_id = p_period_of_service_id
1911: and l_final_process_date between asg.effective_start_date
1912: and asg.effective_end_date
1913: and exists (

Line 1915: from per_all_assignments_f a1

1911: and l_final_process_date between asg.effective_start_date
1912: and asg.effective_end_date
1913: and exists (
1914: select 'X'
1915: from per_all_assignments_f a1
1916: where asg.assignment_id = a1.assignment_id
1917: and l_final_process_date+1 between a1.effective_start_date
1918: and a1.effective_end_date)
1919: order by asg.primary_flag;