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

Line 735: p_assignment_id in per_all_assignments_f.assignment_id%type default null)

731:
732: PROCEDURE set_client_info
733: ( p_person_id in per_all_people_f.person_id%type default null,
734: p_position_id in hr_all_positions_f.position_id%type default null,
735: p_assignment_id in per_all_assignments_f.assignment_id%type default null)
736: is
737: cursor c_per_bus_group_id(p_person_id in per_all_people_f.person_id%TYPE) is
738: select ppf.business_group_id
739: from per_all_people_f ppf

Line 750: p_assignment_id in per_all_assignments_f.assignment_id%TYPE) is

746: where pos.position_id = p_position_id
747: and trunc(sysdate) between pos.effective_start_date
748: and pos.effective_end_date;
749: cursor c_asg_bus_group_id(
750: p_assignment_id in per_all_assignments_f.assignment_id%TYPE) is
751: select asg.business_group_id
752: from per_all_assignments_f asg
753: where asg.assignment_id = p_assignment_id
754: and trunc(sysdate) between asg.effective_start_date

Line 752: from per_all_assignments_f asg

748: and pos.effective_end_date;
749: cursor c_asg_bus_group_id(
750: p_assignment_id in per_all_assignments_f.assignment_id%TYPE) is
751: select asg.business_group_id
752: from per_all_assignments_f asg
753: where asg.assignment_id = p_assignment_id
754: and trunc(sysdate) between asg.effective_start_date
755: and asg.effective_end_date;
756: cursor cur_sec_grp(p_business_group_id in