APPS.BEN_RECN_REP dependencies on BEN_ACTL_PREM_F

Line 270: ,ben_actl_prem_f acp

266: ,ben_recn_rep.get_element_val(pen.prtt_enrt_rslt_id,pds.end_date,p_business_group_id,'PRETAX','EEPYC',pen.per_in_ler_id, pds.end_date) ee_ptax_elem_val
267: ,ben_recn_rep.get_element_val(pen.prtt_enrt_rslt_id,pds.end_date,p_business_group_id,'AFTERTAX','EEPYC',pen.per_in_ler_id, pds.end_date) ee_atax_elem_val
268: ,ben_recn_rep.get_element_val(pen.prtt_enrt_rslt_id,pds.end_date,p_business_group_id,null,'ERC',pen.per_in_ler_id, pds.end_date) er_elem_val
269: from ben_prtt_enrt_rslt_f pen
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

Line 374: ,ben_actl_prem_f acp

370: ,ben_recn_rep.get_element_val(pen.prtt_enrt_rslt_id,pds.end_date,p_business_group_id,'PRETAX','EEPYC',pen.per_in_ler_id, pds.end_date) ee_ptax_elem_val
371: ,ben_recn_rep.get_element_val(pen.prtt_enrt_rslt_id,pds.end_date,p_business_group_id,'AFTERTAX','EEPYC',pen.per_in_ler_id, pds.end_date) ee_atax_elem_val
372: ,ben_recn_rep.get_element_val(pen.prtt_enrt_rslt_id,pds.end_date,p_business_group_id,null,'ERC',pen.per_in_ler_id, pds.end_date) er_elem_val
373: from ben_prtt_enrt_rslt_f pen
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

Line 560: ,ben_actl_prem_f apr

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
564: and (p_pgm_id is null or pen.pgm_id = p_pgm_id )

Line 1293: ,ben_actl_prem_f acp

1289: --
1290: cursor c_person is
1291: select distinct per.person_id, pil.ler_id
1292: from ben_prtt_enrt_rslt_f pen
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