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.PQH_FR_STAT_SIT_UTIL dependencies on PER_ALL_PEOPLE_F

Line 21: Function get_employee_type (p_person_id IN per_all_people_f.person_id%TYPE,

17: return number;
18: Function get_general_los (p_person_id IN NUMBER default NULL,
19: p_determination_date IN DATE default NULL)
20: return number;
21: Function get_employee_type (p_person_id IN per_all_people_f.person_id%TYPE,
22: p_determination_date IN DATE) return varchar2;
23: Function get_situation_type (p_person_id IN per_all_people_f.person_id%TYPE,
24: p_determination_date IN DATE) return varchar2;
25: Function get_relationship_type (p_person_id IN per_all_people_f.person_id%TYPE,

Line 23: Function get_situation_type (p_person_id IN per_all_people_f.person_id%TYPE,

19: p_determination_date IN DATE default NULL)
20: return number;
21: Function get_employee_type (p_person_id IN per_all_people_f.person_id%TYPE,
22: p_determination_date IN DATE) return varchar2;
23: Function get_situation_type (p_person_id IN per_all_people_f.person_id%TYPE,
24: p_determination_date IN DATE) return varchar2;
25: Function get_relationship_type (p_person_id IN per_all_people_f.person_id%TYPE,
26: p_determination_date IN DATE) return varchar2;
27: Function get_dependent_age (p_person_id IN per_all_people_f.person_id%TYPE,

Line 25: Function get_relationship_type (p_person_id IN per_all_people_f.person_id%TYPE,

21: Function get_employee_type (p_person_id IN per_all_people_f.person_id%TYPE,
22: p_determination_date IN DATE) return varchar2;
23: Function get_situation_type (p_person_id IN per_all_people_f.person_id%TYPE,
24: p_determination_date IN DATE) return varchar2;
25: Function get_relationship_type (p_person_id IN per_all_people_f.person_id%TYPE,
26: p_determination_date IN DATE) return varchar2;
27: Function get_dependent_age (p_person_id IN per_all_people_f.person_id%TYPE,
28: p_determination_date IN DATE) return number;
29: --

Line 27: Function get_dependent_age (p_person_id IN per_all_people_f.person_id%TYPE,

23: Function get_situation_type (p_person_id IN per_all_people_f.person_id%TYPE,
24: p_determination_date IN DATE) return varchar2;
25: Function get_relationship_type (p_person_id IN per_all_people_f.person_id%TYPE,
26: p_determination_date IN DATE) return varchar2;
27: Function get_dependent_age (p_person_id IN per_all_people_f.person_id%TYPE,
28: p_determination_date IN DATE) return number;
29: --
30: FUNCTION is_situation_renewable(p_emp_stat_situation_id NUMBER,
31: p_statutory_situation_id NUMBER) RETURN VARCHAR2;