APPS.BEN_RECN_REP dependencies on PER_ALL_ASSIGNMENTS_F

Line 278: ,per_all_assignments_f asg

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
280: and (pen.pgm_id = p_pgm_id or p_pgm_id is null)
281: and pen.prtt_enrt_rslt_stat_cd is null
282: and pen.business_group_id = p_business_group_id

Line 382: ,per_all_assignments_f asg

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
384: and (pen.pgm_id = p_pgm_id or p_pgm_id is null)
385: and pen.prtt_enrt_rslt_stat_cd is null
386: and pen.business_group_id = p_business_group_id

Line 484: per_all_assignments_f asg,

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

Line 559: ,per_all_assignments_f asg

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

Line 1298: ,per_all_assignments_f asg

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
1302: and pen.business_group_id = p_business_group_id