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 743: FROM per_all_assignments_f paf

739: BEGIN
740: --
741: SELECT paf.payroll_id, paf.business_group_id, paf.assignment_id
742: INTO p_payroll_id, p_bg_id, p_assignment_id
743: FROM per_all_assignments_f paf
744: WHERE paf.person_id = p_person_id
745: AND p_effective_date BETWEEN paf.effective_start_date
746: AND paf.effective_end_date
747: AND paf.assignment_type = 'E'

Line 2542: FROM per_all_assignments_f paf

2538: BEGIN
2539: --
2540: SELECT paf.payroll_id, paf.business_group_id, paf.assignment_id
2541: INTO p_payroll_id, p_bg_id, p_assignment_id
2542: FROM per_all_assignments_f paf
2543: WHERE paf.person_id = p_person_id
2544: AND p_effective_date BETWEEN paf.effective_start_date
2545: AND paf.effective_end_date
2546: AND paf.assignment_type = 'E'