APPS.PQH_FR_STAT_SIT_UTIL dependencies on PER_ALL_PEOPLE_F

Line 195: from per_all_people_f where

191: return number
192: IS
193: cursor csr_person_info is
194: select business_group_id
195: from per_all_people_f where
196: person_id = p_person_id
197: and p_determination_date between effective_start_date and effective_end_date;
198:
199: l_bg_id number;

Line 216: from per_all_people_f where

212: return number
213: IS
214: cursor csr_person_info is
215: select business_group_id
216: from per_all_people_f where
217: person_id = p_person_id
218: and p_determination_date between effective_start_date and effective_end_date;
219:
220: l_bg_id number;

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

227: NULL, '10', 'M', p_determination_date);
228:
229: end;
230:
231: Function get_employee_type (p_person_id IN per_all_people_f.person_id%TYPE,
232: p_determination_date IN DATE) return varchar2
233: IS
234: Cursor csr_emp_type is
235: SELECT scl.segment10 emp_type

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

249: return l_emp_type;
250:
251: end;
252:
253: Function get_situation_type (p_person_id IN per_all_people_f.person_id%TYPE,
254: p_determination_date IN DATE) return varchar2
255: IS
256: cursor csr_situation_info is
257: select ss.situation_type, ss.situation_name, ss.situation_type_name

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

271:
272: return l_situation_type;
273: end;
274:
275: Function get_relationship_type (p_person_id IN per_all_people_f.person_id%TYPE,
276: p_determination_date IN DATE) return varchar2
277: IS
278: begin
279: return null;

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

278: begin
279: return null;
280: end;
281:
282: Function get_dependent_age (p_person_id IN per_all_people_f.person_id%TYPE,
283: p_determination_date IN DATE) return number
284: IS
285: l_dependent_cnt number;
286: l_dependent_dob date;

Line 298: from per_all_people_f

294: if l_dependent_cnt = 0 then
295: return null;
296: else
297: select max(date_of_birth) into l_dependent_dob
298: from per_all_people_f
299: where person_id in (select contact_person_id
300: from per_contact_relationships
301: where person_id = p_person_id
302: and p_determination_date between date_start and nvl(date_end,hr_general.end_of_time));