DBA Data[Home] [Help]

APPS.BEN_EXTRACT_SEED dependencies on BEN_ENRT_PERD

Line 768: from ben_enrt_perd enp

764:
765:
766: cursor c_enb is
767: select to_char(enp.strt_dt, 'DD-MON-RRRR') || ' - ' || to_char( enp.end_dt, 'DD-MON-RRRR')
768: from ben_enrt_perd enp
769: where ENRT_PERD_ID = p_val
770: ;
771:
772:

Line 1537: from ben_enrt_perd enp ,

1533:
1534:
1535: cursor c_enb is
1536: select ENRT_PERD_ID
1537: from ben_enrt_perd enp ,
1538: ben_pl_f pl,
1539: ben_popl_enrt_typ_cycl_f pet
1540: where to_char(enp.strt_dt, 'DD-MON-RRRR') || ' - ' || to_char( enp.end_dt, 'DD-MON-RRRR') = p_meaning
1541: and pl.name = p_parent_meaning