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.PQH_DE_CHILD_SEQ_PKG dependencies on PER_QUALIFICATIONS

Line 220: from per_qualifications pq

216: pq.QUALIFICATION_ID,
217: pq.QUA_INFORMATION1,
218: pq.START_DATE,
219: pq.END_DATE
220: from per_qualifications pq
221: where pq.BUSINESS_GROUP_ID=lBusiness_group_id
222: and pq.PERSON_ID=lPERSON_ID
223: and pq.START_DATE is not null
224: and pq.END_DATE is not null

Line 232: from per_qualifications xpq

228: (
229: ((months_between(pq.END_DATE ,Date_of_Birth)/12) >21)
230: and exists
231: (select xpq.QUALIFICATION_ID
232: from per_qualifications xpq
233: where
234: xpq.BUSINESS_GROUP_ID=lBusiness_group_id
235: and xpq.PERSON_ID=pq.PERSON_ID
236: and months_between(pq.END_DATE,xpq.START_DATE)<=4