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.PQP_RIW_ENROLL_WRAPPER dependencies on PER_PEOPLE_F

Line 153: FROM per_assignments_f asg,per_people_f per,PER_PERSON_TYPES PPT

149:
150: CURSOR deleg_ass_id
151: IS
152: SELECT asg.assignment_id
153: FROM per_assignments_f asg,per_people_f per,PER_PERSON_TYPES PPT
154: WHERE per.person_id = asg.person_id
155: and ((asg.primary_flag = 'Y' and ppt.system_person_type in ('EMP','CWK','OTHER'))
156: OR (asg.assignment_type = 'A' and ppt.system_person_type ='APL'))
157: and (SYSDATE BETWEEN ASG.EFFECTIVE_START_DATE and ASG.EFFECTIVE_END_DATE)

Line 165: FROM per_assignments_f asg,per_people_f per,PER_PERSON_TYPES PPT

161:
162: CURSOR spon_ass_id
163: IS
164: SELECT asg.assignment_id
165: FROM per_assignments_f asg,per_people_f per,PER_PERSON_TYPES PPT
166: WHERE per.person_id = asg.person_id
167: and ((asg.primary_flag = 'Y' and ppt.system_person_type in ('EMP','CWK','OTHER'))
168: OR (asg.assignment_type = 'A' and ppt.system_person_type ='APL'))
169: and (SYSDATE BETWEEN ASG.EFFECTIVE_START_DATE and ASG.EFFECTIVE_END_DATE)