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 752: p_assignment_id in per_all_assignments_f.assignment_id%type default null)

748:
749: PROCEDURE set_client_info
750: ( p_person_id in per_all_people_f.person_id%type default null,
751: p_position_id in hr_all_positions_f.position_id%type default null,
752: p_assignment_id in per_all_assignments_f.assignment_id%type default null)
753: is
754: cursor c_per_bus_group_id(p_person_id in per_all_people_f.person_id%TYPE) is
755: select ppf.business_group_id
756: from per_all_people_f ppf

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

763: where pos.position_id = p_position_id
764: and trunc(sysdate) between pos.effective_start_date
765: and pos.effective_end_date;
766: cursor c_asg_bus_group_id(
767: p_assignment_id in per_all_assignments_f.assignment_id%TYPE) is
768: select asg.business_group_id
769: from per_all_assignments_f asg
770: where asg.assignment_id = p_assignment_id
771: and trunc(sysdate) between asg.effective_start_date

Line 769: from per_all_assignments_f asg

765: and pos.effective_end_date;
766: cursor c_asg_bus_group_id(
767: p_assignment_id in per_all_assignments_f.assignment_id%TYPE) is
768: select asg.business_group_id
769: from per_all_assignments_f asg
770: where asg.assignment_id = p_assignment_id
771: and trunc(sysdate) between asg.effective_start_date
772: and asg.effective_end_date;
773: cursor cur_sec_grp(p_business_group_id in