DBA Data[Home] [Help]

APPS.BEN_EXT_ENRT dependencies on BEN_PIL_ELCTBL_CHC_POPL

Line 649: ben_pil_elctbl_chc_popl ppopl

645: p_oipl_id number ,
646: p_pil_id number ) is
647: select ppopl.elcns_made_dt elec_made_dt
648: from ben_elig_per_elctbl_chc ece,
649: ben_pil_elctbl_chc_popl ppopl
650: where (p_pgm_id is null or p_pgm_id = ece.pgm_id)
651: and p_pl_id = ece.pl_id
652: and (p_oipl_id is null or p_oipl_id = ece.oipl_id)
653: and (p_pil_id is null or p_pil_id = ece.per_in_ler_id )

Line 666: from ben_pil_elctbl_chc_popl popl

662: cursor c_popl_rslt (p_pgm_id number ,
663: p_pl_id number ,
664: p_pil_id number ) is
665: select popl.elcns_made_dt elec_made_dt
666: from ben_pil_elctbl_chc_popl popl
667: where ( (p_pgm_id is not null and p_pgm_id = popl.pgm_id)
668: or ( p_pgm_id is null and p_pl_id = popl.pl_id )
669: )
670: and p_pil_id = popl.per_in_ler_id