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_ALL_PEOPLE_F

Line 62: from PER_ALL_PEOPLE_F pap,

58: CURSOR C_Emp_In_Business_Grp(lBusiness_group_id number) is
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

Line 159: PER_ALL_PEOPLE_F xpap

155: pcr.Contact_Relationship_Id in
156: (select
157: xpcr.Contact_Relationship_Id
158: from PER_CONTACT_RELATIONSHIPS xpcr,
159: PER_ALL_PEOPLE_F xpap
160: where xpcr.BUSINESS_GROUP_ID=lBusiness_group_id
161: and xpcr.PERSON_ID=xpap.PERSON_ID
162: and xpap.PERSON_ID=lPerson_id
163: and nvl(xpcr.DATE_START,l_session_date) <= l_session_date

Line 203: from PER_ALL_PEOPLE_F pap,

199: pei.pei_information1, --Start Date
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

Line 538: from PER_ALL_PEOPLE_F pap,

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