DBA Data[Home] [Help]

APPS.BEN_RECN_REP dependencies on PER_PERSON_TYPES

Line 275: ,per_person_types ptp

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
279: where pen.pl_id = p_pl_id

Line 379: ,per_person_types ptp

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
383: where pen.pl_id = p_pl_id

Line 485: per_person_types ptp

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 )
488: and pen.prtt_enrt_rslt_stat_cd is null
489: and pen.business_group_id = p_business_group_id

Line 558: ,per_person_types ptp

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
562: ,ben_prtt_prem_by_mo_f popl