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.HR_PERSON_RECORD dependencies on PER_PHONES

Line 1256: FROM PER_PHONES

1252: ATTRIBUTE29,
1253: ATTRIBUTE30,
1254: PARTY_ID,
1255: VALIDITY
1256: FROM PER_PHONES
1257: WHERE PARENT_ID = p_person_id
1258: AND PARENT_TABLE = 'PER_ALL_PEOPLE_F'
1259: and p_eff_date between DATE_FROM and nvl(DATE_TO,to_date('31/12/4712','DD/MM/YYYY'));
1260:

Line 2442: ,per_phones pp

2438:
2439: select distinct ppf.person_id ,ppf.business_group_id,p_srch_criteria(i).p_effective_date
2440: from per_people_f ppf
2441: ,per_person_types ppt
2442: ,per_phones pp
2443: where ppf.business_group_id = nvl(p_bus_group_id,ppf.business_group_id)
2444: and p_srch_criteria(i).p_effective_date between ppf.effective_start_date and ppf.effective_end_date
2445: and ppf.person_id = pp.parent_id(+)
2446: and pp.parent_table = 'PER_ALL_PEOPLE_F'