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_ASSIGNMENTS_F

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

515:
516: CURSOR deleg_ass_id
517: IS
518: SELECT asg.assignment_id
519: FROM per_assignments_f asg,per_people_f per,PER_PERSON_TYPES PPT
520: WHERE per.person_id = asg.person_id
521: and ((asg.primary_flag = 'Y' and ppt.system_person_type in ('EMP','CWK','OTHER'))
522: OR (asg.assignment_type = 'A' and ppt.system_person_type ='APL'))
523: and (SYSDATE BETWEEN ASG.EFFECTIVE_START_DATE and ASG.EFFECTIVE_END_DATE)

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

527:
528: CURSOR spon_ass_id
529: IS
530: SELECT asg.assignment_id
531: FROM per_assignments_f asg,per_people_f per,PER_PERSON_TYPES PPT
532: WHERE per.person_id = asg.person_id
533: and ((asg.primary_flag = 'Y' and ppt.system_person_type in ('EMP','CWK','OTHER'))
534: OR (asg.assignment_type = 'A' and ppt.system_person_type ='APL'))
535: and (SYSDATE BETWEEN ASG.EFFECTIVE_START_DATE and ASG.EFFECTIVE_END_DATE)