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.HXT_OTC_RETRIEVAL_INTERFACE dependencies on PER_ALL_ASSIGNMENTS_F

Line 242: FROM per_all_assignments_f paf

238: BEGIN
239: --
240: SELECT paf.payroll_id, paf.business_group_id, paf.assignment_id
241: INTO p_payroll_id, p_bg_id, p_assignment_id
242: FROM per_all_assignments_f paf
243: WHERE paf.person_id = p_person_id
244: AND p_effective_date BETWEEN paf.effective_start_date
245: AND paf.effective_end_date
246: AND paf.assignment_type = 'E'

Line 1888: FROM per_all_assignments_f paf

1884: BEGIN
1885: --
1886: SELECT paf.payroll_id, paf.business_group_id, paf.assignment_id
1887: INTO p_payroll_id, p_bg_id, p_assignment_id
1888: FROM per_all_assignments_f paf
1889: WHERE paf.person_id = p_person_id
1890: AND p_effective_date BETWEEN paf.effective_start_date
1891: AND paf.effective_end_date
1892: AND paf.assignment_type = 'E'