APPS.PQH_FR_STAT_SIT_UTIL dependencies on PER_CONTACT_RELATIONSHIPS

Line 291: from per_contact_relationships

287: l_dependent_age number;
288:
289: begin
290: select count(1) into l_dependent_cnt
291: from per_contact_relationships
292: where person_id = p_person_id
293: and p_determination_date between date_start and nvl(date_end,hr_general.end_of_time);
294: if l_dependent_cnt = 0 then
295: return null;

Line 300: from per_contact_relationships

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));
303: l_dependent_age := Months_Between(p_determination_date,l_dependent_dob)/12;
304: return l_dependent_age;