APPS.BEN_RECN_REP dependencies on PER_ALL_PEOPLE_F

Line 274: ,per_all_people_f per

270: ,ben_actl_prem_f acp
271: ,ben_prtt_prem_f prm
272: ,ben_prtt_prem_by_mo_f mpr
273: ,ben_per_in_ler pil
274: ,per_all_people_f per
275: ,per_person_types ptp
276: ,pay_all_payrolls_f pay
277: ,per_time_periods pds
278: ,per_all_assignments_f asg

Line 378: ,per_all_people_f per

374: ,ben_actl_prem_f acp
375: ,ben_prtt_prem_f prm
376: ,ben_prtt_prem_by_mo_f mpr
377: ,ben_per_in_ler pil
378: ,per_all_people_f per
379: ,per_person_types ptp
380: ,pay_all_payrolls_f pay
381: ,per_time_periods pds
382: ,per_all_assignments_f asg

Line 483: per_all_people_f per,

479: ben_per_in_ler pil,
480: ben_ler_f ler ,
481: ben_prtt_prem_f prm ,
482: ben_prtt_prem_by_mo_f popl,
483: per_all_people_f per,
484: per_all_assignments_f asg,
485: per_person_types ptp
486: where pen.pl_id = p_pl_id
487: and (p_pgm_id is null or pen.pgm_id = p_pgm_id )

Line 557: ,per_all_people_f per

553: apr.pl_id ,
554: ben_recn_rep.get_prtt_rate_val(pen.prtt_enrt_rslt_id , p_report_start_date, pen.per_in_ler_id, p_report_end_date) rate-- 3608119
555: from ben_prtt_enrt_rslt_f pen
556: ,ben_per_in_ler pil
557: ,per_all_people_f per
558: ,per_person_types ptp
559: ,per_all_assignments_f asg
560: ,ben_actl_prem_f apr
561: ,ben_prtt_prem_f prm

Line 641: l_person per_all_people_f.full_name%type;

637: l_plan_disc_rep_header varchar2(2000);
638: l_plan_prtt_rep_header varchar2(2000);
639: l_lfe_rep_header varchar2(2000);
640: --
641: l_person per_all_people_f.full_name%type;
642: l_emp_name_format varchar2(80);
643: l_pgm ben_pgm_f.name%type;
644: l_pl ben_pl_f.name%type;
645: l_per_sel_rule ff_formulas_f.formula_name%type;

Line 1297: ,per_all_people_f per

1293: ,ben_actl_prem_f acp
1294: ,ben_prtt_prem_f prm
1295: ,ben_prtt_prem_by_mo_f mpr
1296: ,ben_per_in_ler pil
1297: ,per_all_people_f per
1298: ,per_all_assignments_f asg
1299: where pen.pl_id = p_pl_id
1300: and (p_pgm_id is null or pen.pgm_id = p_pgm_id)
1301: and pen.prtt_enrt_rslt_stat_cd is null

Line 1828: from per_all_people_f per

1824: as
1825: --
1826: cursor c_person is
1827: select per.full_name
1828: from per_all_people_f per
1829: where per.person_id = p_person_id
1830: and p_run_date between nvl(per.effective_start_date,p_run_date)
1831: and nvl(per.effective_end_date,p_run_date);
1832: --