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.IRC_UTILITIES_PKG dependencies on PER_ESTABLISHMENT_ATTENDANCES

Line 217: PER_ESTABLISHMENT_ATTENDANCES ESTAB,

213: ,p_max_rank number) IS
214: SELECT QTYP.NAME
215: FROM PER_QUALIFICATION_TYPES QTYP,
216: PER_QUALIFICATIONS QUAL,
217: PER_ESTABLISHMENT_ATTENDANCES ESTAB,
218: PER_ALL_PEOPLE_F ppf,
219: PER_ALL_PEOPLE_F ppf2
220: WHERE ppf.person_id = p_person
221: AND ppf.party_id = ppf2.party_id

Line 277: PER_ESTABLISHMENT_ATTENDANCES ESTAB,

273: CURSOR c_qual_types2 IS
274: SELECT /*+ FIRST_ROWS */ QTYP.NAME
275: FROM PER_QUALIFICATION_TYPES QTYP,
276: PER_QUALIFICATIONS QUAL,
277: PER_ESTABLISHMENT_ATTENDANCES ESTAB,
278: PER_ALL_PEOPLE_F ppf
279: WHERE ppf.party_id = p_party_id
280: AND trunc(sysdate) BETWEEN ppf.effective_start_date and ppf.effective_end_date
281: AND ppf.person_id = ESTAB.PERSON_ID