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.GHR_BEN_VALIDATION dependencies on PER_ASSIGNMENTS_F

Line 1199: CURSOR c_assignment(c_person_id per_assignments_f.person_id%type,

1195: p_person_extra_info_id number,
1196: p_information_type in varchar2,
1197: p_person_id in number
1198: ) IS
1199: CURSOR c_assignment(c_person_id per_assignments_f.person_id%type,
1200: c_effective_date per_assignments_f.effective_start_date%type) IS
1201: SELECT assignment_type, assignment_id
1202: FROM per_all_assignments_f asg
1203: WHERE asg.person_id = c_person_id

Line 1200: c_effective_date per_assignments_f.effective_start_date%type) IS

1196: p_information_type in varchar2,
1197: p_person_id in number
1198: ) IS
1199: CURSOR c_assignment(c_person_id per_assignments_f.person_id%type,
1200: c_effective_date per_assignments_f.effective_start_date%type) IS
1201: SELECT assignment_type, assignment_id
1202: FROM per_all_assignments_f asg
1203: WHERE asg.person_id = c_person_id
1204: AND c_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date;