APPS.BEN_DETERMINE_DATE dependencies on BEN_PIL_ELCTBL_CHC_POPL

Line 888: from ben_pil_elctbl_chc_popl pel,

884: --
885: cursor c_pil_popl is
886: select pel.enrt_perd_end_dt,
887: pel.procg_end_dt
888: from ben_pil_elctbl_chc_popl pel,
889: ben_elig_per_elctbl_chc epe
890: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
891: and epe.business_group_id = l_business_group_id
892: and epe.pil_elctbl_chc_popl_id = pel.pil_elctbl_chc_popl_id

Line 902: from ben_pil_elctbl_chc_popl

898: -- where clause this should only return 1 row.
899: --
900: cursor c_cm_enrt_perd_strt_dt is
901: select enrt_perd_strt_dt
902: from ben_pil_elctbl_chc_popl
903: where per_in_ler_id = l_per_in_ler_id
904: and ((l_pgm_id is not null and pgm_id = l_pgm_id)
905: or (l_pgm_id is null and pl_id = l_pl_id)
906: or (l_pgm_id is null and l_pl_id is null))

Line 911: from ben_pil_elctbl_chc_popl

907: and business_group_id = l_business_group_id;
908: --
909: cursor c_cm_enrt_perd_end_dt is
910: select min(enrt_perd_end_dt)
911: from ben_pil_elctbl_chc_popl
912: where per_in_ler_id = l_per_in_ler_id
913: and ((l_pgm_id is not null and pgm_id = l_pgm_id)
914: or (l_pgm_id is null and pl_id = l_pl_id)
915: or (l_pgm_id is null and l_pl_id is null))

Line 920: from ben_pil_elctbl_chc_popl

916: and business_group_id = l_business_group_id;
917: --
918: cursor c_cm_dflt_asnd_dt is
919: select min(dflt_asnd_dt)
920: from ben_pil_elctbl_chc_popl
921: where per_in_ler_id = l_per_in_ler_id
922: and ((l_pgm_id is not null and pgm_id = l_pgm_id)
923: or (l_pgm_id is null and pl_id = l_pl_id)
924: or (l_pgm_id is null and l_pl_id is null))

Line 929: from ben_pil_elctbl_chc_popl

925: and business_group_id = l_business_group_id;
926: --
927: cursor c_cm_auto_asnd_dt is
928: select min(auto_asnd_dt)
929: from ben_pil_elctbl_chc_popl
930: where per_in_ler_id = l_per_in_ler_id
931: and ((l_pgm_id is not null and pgm_id = l_pgm_id)
932: or (l_pgm_id is null and pl_id = l_pl_id)
933: or (l_pgm_id is null and l_pl_id is null))

Line 938: from ben_pil_elctbl_chc_popl

934: and business_group_id = l_business_group_id;
935: --
936: cursor c_cm_elcns_made_dt is
937: select min(elcns_made_dt)
938: from ben_pil_elctbl_chc_popl
939: where per_in_ler_id = l_per_in_ler_id
940: and ((l_pgm_id is not null and pgm_id = l_pgm_id)
941: or (l_pgm_id is null and pl_id = l_pl_id)
942: or (l_pgm_id is null and l_pl_id is null))

Line 7156: ben_pil_elctbl_chc_popl pel,

7152: pil.person_id,
7153: epe.fonm_cvg_strt_dt
7154: from
7155: ben_elig_per_elctbl_chc epe,
7156: ben_pil_elctbl_chc_popl pel,
7157: ben_per_in_ler pil
7158: where
7159: epe.elig_per_elctbl_chc_id=p_elig_per_elctbl_chc_id and
7160: pel.pil_elctbl_chc_popl_id = epe.pil_elctbl_chc_popl_id and