DBA Data[Home] [Help]

APPS.GHR_UTILITY dependencies on PER_ALL_PEOPLE_F

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

729: RETURN v_is_ghr_nfc;
730: END;
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

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

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

Line 739: from per_all_people_f ppf

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