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_PAR_BUS dependencies on PER_ALL_ASSIGNMENTS_F

Line 694: FROM per_all_assignments_f asg

690: WHERE par.pa_request_id = p_pa_request_id;
691:
692: cursor cur_asg_id is
693: SELECT person_id
694: FROM per_all_assignments_f asg
695: WHERE asg.assignment_id = p_employee_assignment_id;
696:
697: cursor cur_asg_dt_id is
698: SELECT 1

Line 699: FROM per_all_assignments_f asg

695: WHERE asg.assignment_id = p_employee_assignment_id;
696:
697: cursor cur_asg_dt_id is
698: SELECT 1
699: FROM per_all_assignments_f asg
700: WHERE asg.assignment_id = p_employee_assignment_id
701: AND nvl(p_effective_date,sysdate)
702: BETWEEN asg.effective_start_date and asg.effective_end_date;
703: --7015822

Line 837: FROM per_all_assignments_f asg

833: l_ed_date date;
834: --
835: cursor cur_pos_id is
836: SELECT 1
837: FROM per_all_assignments_f asg
838: WHERE asg.assignment_id = p_employee_assignment_id
839: AND asg.position_id = p_from_position_id;
840: --
841: begin