APPS.PER_JP_EMPDET_REPORT_PKG dependencies on PER_PEOPLE_F

Line 531: ' from per_people_f p,'||

527: hr_utility.set_location ('P_PAYROLL_ACTION_ID = '|| p_payroll_action_id,50);
528: END IF;
529: --
530: p_sqlstr := ' select distinct p.person_id'||
531: ' from per_people_f p,'||
532: ' pay_payroll_actions pa'||
533: ' where pa.payroll_action_id = :payroll_action_id'||
534: ' and p.business_group_id = pa.business_group_id'||
535: ' order by p.person_id ';

Line 598: ,per_people_f PPF

594:
595: sqlstr := ' SELECT PAA.rowid
596: FROM per_assignments_f PAF
597: ,pay_assignment_actions PAA
598: ,per_people_f PPF
599: ,hr_all_organization_units HAOU
600: ,per_periods_of_service PPS
601: WHERE PAA.payroll_action_id = :pactid
602: AND PAF.assignment_id = PAA.assignment_id

Line 692: ,per_people_f PPF

688:
689: sqlstr := ' SELECT PAA.rowid
690: FROM per_assignments_f PAF
691: ,pay_assignment_actions PAA
692: ,per_people_f PPF
693: ,hr_all_organization_units_tl HAOUT
694: ,hr_all_organization_units HAOU
695: ,per_periods_of_service PPS
696: WHERE PAA.payroll_action_id = :pactid

Line 847: ,per_people_f PAP

843: IS
844: SELECT PJEDV.assignment_id
845: ,PJEDV.effective_date
846: FROM per_assignments_f PAA
847: ,per_people_f PAP
848: ,pay_assignment_actions PAS
849: ,per_jp_empdet_emp_v PJEDV
850: ,per_periods_of_service PPOF
851: ,pay_population_ranges PPR

Line 901: ,per_people_f PAP

897: IS
898: SELECT PJEDV.assignment_id
899: ,PJEDV.effective_date
900: FROM per_assignments_f PAA
901: ,per_people_f PAP
902: ,pay_assignment_actions PAS
903: ,per_periods_of_service PPS
904: ,per_jp_empdet_emp_v PJEDV
905: WHERE PAA.person_id = PAP.person_id