APPS.PAY_JP_UITE_REPORT_PKG dependencies on PER_PEOPLE_F

Line 639: ' from per_people_f p,'||

635: hr_utility.trace ('P_PAYROLL_ACTION_ID = '|| p_payroll_action_id);
636: END IF;
637: --
638: p_sqlstr := ' select distinct p.person_id'||
639: ' from per_people_f p,'||
640: ' pay_payroll_actions pa'||
641: ' where pa.payroll_action_id = :payroll_action_id'||
642: ' and p.business_group_id = pa.business_group_id'||
643: ' order by p.person_id ';

Line 694: ,per_people_f PAP

690: IS
691: SELECT DISTINCT PJUIEV.assignment_id
692: ,PJUIEV.termination_date
693: FROM per_assignments_f PAA
694: ,per_people_f PAP
695: ,pay_assignment_actions PAS
696: ,pay_jp_uite_emp_v PJUIEV
697: ,per_periods_of_service PPOF
698: ,pay_population_ranges PPR

Line 727: ,per_people_f PAP

723: IS
724: SELECT DISTINCT PJUIEV.assignment_id
725: ,PJUIEV.termination_date
726: FROM per_assignments_f PAA
727: ,per_people_f PAP
728: ,pay_assignment_actions PAS
729: ,pay_jp_uite_emp_v PJUIEV
730: ,per_periods_of_service PPOF
731: ,hr_all_organization_units HAOU

Line 1591: ,per_people_f PPF

1587:
1588: sqlstr := ' SELECT PAA.rowid
1589: FROM per_assignments_f PAF
1590: ,pay_assignment_actions PAA
1591: ,per_people_f PPF
1592: ,hr_all_organization_units_tl HAOUT
1593: ,hr_all_organization_units HAOU
1594: ,per_periods_of_service PPS
1595: WHERE PAA.payroll_action_id = :pactid