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_PEOPLE_EXTRA_INFO

Line 64: PER_PEOPLE_EXTRA_INFO pei

60: pap.EFFECTIVE_START_DATE,
61: pap.EFFECTIVE_END_DATE
62: from PER_ALL_PEOPLE_F pap,
63: PER_PERSON_TYPES ppt,
64: PER_PEOPLE_EXTRA_INFO pei
65: where
66: pap.BUSINESS_GROUP_ID=lBusiness_group_id
67: and pap.person_type_id=ppt.person_type_id
68: and ppt.SYSTEM_PERSON_TYPE='EMP'

Line 153: PER_PEOPLE_EXTRA_INFO pei

149: pei.pei_information3
150:
151: from PER_CONTACT_RELATIONSHIPS pcr,
152: PER_PEOPLE_F pap,
153: PER_PEOPLE_EXTRA_INFO pei
154: where
155: pcr.Contact_Relationship_Id in
156: (select
157: xpcr.Contact_Relationship_Id

Line 204: PER_PEOPLE_EXTRA_INFO pei

200: pei.pei_information2, --End Date
201: pei.pei_information3, --Type of Service
202: pei.pei_information4 --Certificate Presented
203: from PER_ALL_PEOPLE_F pap,
204: PER_PEOPLE_EXTRA_INFO pei
205: where
206: pap.BUSINESS_GROUP_ID=lBusiness_group_id
207: and pap.PERSON_ID= lCHILD_ID
208: and pei.PERSON_ID=pap.PERSON_ID