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 297: FROM per_all_people_f per, per_all_assignments_f asg

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

Line 322: FROM per_all_people_f per2

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

Line 382: FROM per_all_people_f per, per_all_assignments_f asg

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

Line 396: FROM per_all_people_f per2

392: )
393: )
394: AND national_identifier in
395: (SELECT national_identifier
396: FROM per_all_people_f per2
397: WHERE person_id = p_person_id
398: -- AND p_effective_date BETWEEN per2.effective_start_date
399: -- AND per2.effective_end_date
400: )

Line 624: FROM per_all_people_f per, per_all_assignments_f asg

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

Line 662: FROM per_all_people_f per, per_all_assignments_f asg

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

Line 685: FROM per_all_people_f per2

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