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_GB_T1_PENSION_EXTRACTS dependencies on PER_ALL_PEOPLE_F

Line 294: FROM per_all_people_f per, per_all_assignments_f asg

290: ,asg.business_group_id business_group_id
291: ,DECODE(asg.business_group_id
292: ,g_business_group_id, 0
293: ,asg.business_group_id) bizgrpcol
294: FROM per_all_people_f per, per_all_assignments_f asg
295: ,per_assignment_status_types pss
296: WHERE per.person_id <> p_person_id
297: AND ((p_effective_date BETWEEN per.effective_start_date
298: AND per.effective_end_date)

Line 319: FROM per_all_people_f per2

315: )
316: )
317: AND national_identifier IN
318: (SELECT national_identifier
319: FROM per_all_people_f per2
320: WHERE per2.person_id = p_person_id
321: AND ((p_effective_date BETWEEN per2.effective_start_date
322: AND per2.effective_end_date)
323: -- ENH3: Cross Person Reporting.

Line 379: FROM per_all_people_f per, per_all_assignments_f asg

375: ,asg.business_group_id business_group_id
376: ,DECODE(asg.business_group_id
377: ,g_business_group_id, 0
378: ,asg.business_group_id) bizgrpcol
379: FROM per_all_people_f per, per_all_assignments_f asg
380: WHERE per.person_id <> p_person_id
381: AND p_effective_date BETWEEN per.effective_start_date
382: AND per.effective_end_date
383: AND g_cross_per_enabled = 'Y' -- Cross Person is enabled

Line 393: FROM per_all_people_f per2

389: )
390: )
391: AND national_identifier =
392: (SELECT national_identifier
393: FROM per_all_people_f per2
394: WHERE person_id = p_person_id
395: AND p_effective_date BETWEEN per2.effective_start_date
396: AND per2.effective_end_date
397: )

Line 621: FROM per_all_people_f per, per_all_assignments_f asg

617: ,per.national_identifier
618: ,per.business_group_id
619: ,asg.assignment_id assignment_id
620: ,NVL(asg.employment_category,'FT') asg_emp_cat_cd
621: FROM per_all_people_f per, per_all_assignments_f asg
622: WHERE per.person_id = p_person_id
623: AND asg.assignment_id <> p_assignment_id
624: AND asg.assignment_type ='E'
625: --AND p_effective_date BETWEEN per.effective_start_date

Line 659: FROM per_all_people_f per, per_all_assignments_f asg

655: ,per.national_identifier
656: ,per.business_group_id
657: ,asg.assignment_id assignment_id
658: ,NVL(asg.employment_category,'FT') asg_emp_cat_cd
659: FROM per_all_people_f per, per_all_assignments_f asg
660: WHERE per.person_id <> p_person_id
661: -- AND p_effective_date BETWEEN per.effective_start_date
662: -- AND per.effective_end_date
663: AND (

Line 682: FROM per_all_people_f per2

678: AND national_identifier IN -- changed from = to IN as the query
679: -- return multiple records, in case there are
680: -- date track updates on person record.
681: (SELECT national_identifier
682: FROM per_all_people_f per2
683: WHERE person_id = p_person_id
684: --AND p_effective_date BETWEEN per2.effective_start_date
685: -- AND per2.effective_end_date
686: AND (