DBA Data[Home] [Help]

APPS.BEN_RECN_REP dependencies on BEN_PRTT_PREM_BY_MO_F

Line 272: ,ben_prtt_prem_by_mo_f mpr

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
275: ,per_person_types ptp
276: ,pay_all_payrolls_f pay

Line 376: ,ben_prtt_prem_by_mo_f mpr

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
379: ,per_person_types ptp
380: ,pay_all_payrolls_f pay

Line 482: ben_prtt_prem_by_mo_f popl,

478: from ben_prtt_enrt_rslt_f pen,
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

Line 562: ,ben_prtt_prem_by_mo_f popl

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

Line 1295: ,ben_prtt_prem_by_mo_f mpr

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
1298: ,per_all_assignments_f asg
1299: where pen.pl_id = p_pl_id

Line 1444: ,ben_prtt_prem_by_mo_f popl

1440: pen.prtt_enrt_rslt_id
1441: from ben_prtt_enrt_rslt_f pen
1442: ,ben_per_in_ler pil
1443: ,ben_prtt_prem_f prm
1444: ,ben_prtt_prem_by_mo_f popl
1445: where pen.pl_id = p_pl_id
1446: and (c_pgm_id is null or pen.pgm_id = c_pgm_id )
1447: and (c_oipl_id is null or pen.oipl_id = c_oipl_id )
1448: and pen.person_id = p_person_id