APPS.PAY_JP_IWHT_REPORT_PKG dependencies on PER_PEOPLE_F

Line 665: ' from per_people_f p,'||

661: hr_utility.trace ('P_PAYROLL_ACTION_ID = '|| p_payroll_action_id);
662: END IF;
663: --
664: p_sqlstr := ' select distinct p.person_id'||
665: ' from per_people_f p,'||
666: ' pay_payroll_actions pa'||
667: ' where pa.payroll_action_id = :payroll_action_id'||
668: ' and p.business_group_id = pa.business_group_id'||
669: ' order by p.person_id ';

Line 725: ,per_people_f PAP

721: IS
722: SELECT DISTINCT PJIWTV.assignment_id
723: ,PJIWTV.term_payment_date
724: FROM per_assignments_f PAA
725: ,per_people_f PAP
726: ,pay_assignment_actions PAS
727: ,pay_jp_iwht_tax_v PJIWTV
728: ,per_periods_of_service PPOF
729: ,pay_population_ranges PPR

Line 763: ,per_people_f PAP

759: IS
760: SELECT DISTINCT PJIWTV.assignment_id
761: ,PJIWTV.term_payment_date
762: FROM per_assignments_f PAA
763: ,per_people_f PAP
764: ,pay_assignment_actions PAS
765: ,pay_jp_iwht_tax_v PJIWTV
766: ,per_periods_of_service PPOF
767: ,hr_all_organization_units HAOU

Line 1520: ,per_people_f PPF

1516:
1517: sqlstr := ' SELECT PAA.rowid
1518: FROM per_assignments_f PAF
1519: ,pay_assignment_actions PAA
1520: ,per_people_f PPF
1521: ,hr_all_organization_units_tl HAOUT
1522: ,hr_all_organization_units HAOU
1523: ,per_periods_of_service PPS
1524: ,pay_jp_iwht_emp_v PJIWEV