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_PERSON_TYPES

Line 63: PER_PERSON_TYPES ppt,

59: select pap.PERSON_ID,
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

Line 539: PER_PERSON_TYPES ppt

535: pap.EFFECTIVE_START_DATE,
536: pap.EFFECTIVE_END_DATE
537:
538: from PER_ALL_PEOPLE_F pap,
539: PER_PERSON_TYPES ppt
540: where
541: pap.PERSON_ID=lPERSON_ID
542: and pap.BUSINESS_GROUP_ID=lBusiness_group_id
543: and pap.person_type_id=ppt.person_type_id