APPS.PER_JP_DEPENDENT_PKG dependencies on PER_PHONES

Line 288: SELECT COUNT(parent_id) FROM per_phones

284: p_person_id IN NUMBER,
285: p_effective_date IN DATE) RETURN NUMBER IS
286: --
287: CURSOR cel_phone_exist IS
288: SELECT COUNT(parent_id) FROM per_phones
289: WHERE parent_id = p_person_id
290: AND parent_table = 'PER_ALL_PEOPLE_F'
291: AND p_effective_date BETWEEN date_from AND NVL(date_to,p_effective_date);
292: --

Line 319: FROM per_phones

315: SUBSTRB(hr_general.decode_lookup('PHONE_TYPE',phone_type),1,80) phone_type_meaning,
316: phone_number,
317: date_from,
318: date_to
319: FROM per_phones
320: WHERE parent_id = p_person_id
321: AND parent_table = 'PER_ALL_PEOPLE_F'
322: AND p_effective_date BETWEEN date_from AND NVL(date_to,p_effective_date);
323: --