APPS.PER_JP_WRKREG_REPORT_PKG dependencies on PER_PEOPLE_F

Line 381: ' from per_people_f p,'||

377: --
378: initialize(p_payroll_action_id);
379: --
380: p_sqlstr := ' select distinct p.person_id'||
381: ' from per_people_f p,'||
382: ' pay_payroll_actions pa'||
383: ' where pa.payroll_action_id = :payroll_action_id'||
384: ' and p.business_group_id = pa.business_group_id'||
385: ' order by p.person_id ';

Line 440: ,per_people_f PPF

436: -- Bug 8691511
437: sqlstr := ' SELECT PAA.rowid
438: FROM per_assignments_f PAF
439: ,pay_assignment_actions PAA
440: ,per_people_f PPF
441: ,hr_all_organization_units_tl HAOUT
442: ,hr_all_organization_units HAOU
443: ,per_periods_of_service PPS
444: WHERE PAA.payroll_action_id = :pactid

Line 604: ,per_people_f PAP

600: IS
601: SELECT PJWREV.assignment_id
602: ,PJWREV.effective_date
603: FROM per_assignments_f PAA
604: ,per_people_f PAP
605: ,pay_assignment_actions PAS
606: ,per_jp_wrkreg_emp_v PJWREV
607: ,per_periods_of_service PPOF
608: ,pay_population_ranges PPR

Line 660: ,per_people_f PAP

656: IS
657: SELECT PJWREV.assignment_id
658: ,PJWREV.effective_date
659: FROM per_assignments_f PAA
660: ,per_people_f PAP
661: ,pay_assignment_actions PAS
662: ,per_jp_wrkreg_emp_v PJWREV
663: ,per_periods_of_service PPOF
664: ,hr_all_organization_units HAOU