DBA Data[Home] [Help]

APPS.BEN_DETERMINE_ACTIVITY_BASE_RT dependencies on BEN_ELIG_PER_F

Line 994: from ben_elig_per_f ep,

990: ,c_effective_date in date
991: )
992: is
993: select epo.prtn_strt_dt
994: from ben_elig_per_f ep,
995: ben_elig_per_opt_f epo,
996: ben_per_in_ler pil
997: where ep.person_id=c_person_id
998: and nvl(ep.pgm_id,-1)=c_pgm_id

Line 1012: from ben_elig_per_f ep,

1008: or
1009: pil.per_in_ler_stat_cd is null)
1010: union
1011: select prtn_strt_dt
1012: from ben_elig_per_f ep,
1013: ben_per_in_ler pil
1014: where ep.person_id=c_person_id
1015: and nvl(ep.pgm_id,-1)=c_pgm_id
1016: and ep.pl_id=c_pl_id