DBA Data[Home] [Help]

APPS.BEN_DET_IMPUTED_INCOME dependencies on BEN_PIL_ELCTBL_CHC_POPL

Line 743: from ben_per_in_ler pil, ben_pil_elctbl_chc_popl popl

739: -- cursor used to determine l_cvg_strt_dt
740: cursor c_pil_popl
741: is
742: select pil.lf_evt_ocrd_dt, popl.elcns_made_dt, popl.dflt_asnd_dt, popl.dflt_enrt_dt
743: from ben_per_in_ler pil, ben_pil_elctbl_chc_popl popl
744: where popl.per_in_ler_id (+) = pil.per_in_ler_id
745: and pil.per_in_ler_id = p_per_in_ler_id;
746:
747: l_pil_popl c_pil_popl%rowtype;

Line 761: ben_pil_elctbl_chc_popl pel /* bug 10262697 */

757: epe.fonm_cvg_strt_dt
758: from ben_elig_per_elctbl_chc epe,
759: ben_per_in_ler pil,
760: ben_pl_f pl,
761: ben_pil_elctbl_chc_popl pel /* bug 10262697 */
762: where epe.PER_IN_LER_ID = p_per_in_ler_id
763: and pil.per_in_ler_id = p_per_in_ler_id
764: and pil.per_in_ler_stat_cd not in ('BCKDT','VOIDD')
765: and epe.pl_id = pl.pl_id