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_PEOPLE_F

Line 750: ( p_person_id in per_all_people_f.person_id%type default null,

746: RETURN v_is_ghr_ben_fegli;
747: END;
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

Line 754: cursor c_per_bus_group_id(p_person_id in per_all_people_f.person_id%TYPE) is

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
757: where ppf.person_id = p_person_id
758: and trunc(sysdate) between ppf.effective_start_date

Line 756: from per_all_people_f ppf

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
757: where ppf.person_id = p_person_id
758: and trunc(sysdate) between ppf.effective_start_date
759: and ppf.effective_end_date;
760: cursor c_pos_bus_group_id(p_position_id in hr_all_positions_f.position_id%TYPE ) is