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_FORMULA_FUNCTIONS dependencies on PER_PEOPLE_F

Line 346: l_person_id per_people_f.person_id%type;

342: )
343: RETURN varchar2 is
344: l_procedure_name varchar2(100);
345: l_person_type per_person_types.system_person_type%type;
346: l_person_id per_people_f.person_id%type;
347: l_session_date fnd_sessions.effective_date%type;
348: cursor c_get_session_date is
349: select trunc(effective_date) session_date
350: from fnd_sessions

Line 364: FROM per_people_f ppf, per_person_types pty

360: between effective_start_date
361: and effective_end_date;
362: cursor get_person_type is
363: SELECT pty.system_person_type
364: FROM per_people_f ppf, per_person_types pty
365: WHERE ppf.person_id = l_person_id
366: AND l_session_date
367: BETWEEN ppf.effective_start_date AND ppf.effective_end_date
368: AND ppf.person_type_id = pty.person_type_id