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

Line 132: FROM per_phones pp,per_all_people_f ppf

128:
129: /* Cursor for fetching person's phone details */
130: CURSOR csr_p_phone_data (l_person_id number,l_ph_type varchar2,l_effective_date date) IS
131: SELECT pp.phone_number
132: FROM per_phones pp,per_all_people_f ppf
133: WHERE pp.parent_id = ppf.person_id
134: AND pp.phone_type = l_ph_type
135: AND ppf.person_id = l_person_id
136: AND l_effective_date between pp.date_from and nvl(pp.date_to,to_date('31-12-4712','DD-MM-YYYY'));

Line 1251: FROM per_phones pp,per_all_people_f ppf

1247:
1248: /* Cursor for fetching person's phone details */
1249: CURSOR csr_p_phone_data (l_person_id number,l_ph_type varchar2,l_effective_date date) IS
1250: SELECT pp.phone_number
1251: FROM per_phones pp,per_all_people_f ppf
1252: WHERE pp.parent_id = ppf.person_id
1253: AND pp.phone_type = l_ph_type
1254: AND ppf.person_id = l_person_id
1255: AND l_effective_date between pp.date_from and nvl(pp.date_to,to_date('31-12-4712','DD-MM-YYYY'));