DBA Data[Home] [Help]

APPS.BEN_DETERMINE_ACTIVITY_BASE_RT dependencies on BEN_ELIG_PER_F

Line 1011: from ben_elig_per_f ep,

1007: ,c_effective_date in date
1008: )
1009: is
1010: select epo.prtn_strt_dt
1011: from ben_elig_per_f ep,
1012: ben_elig_per_opt_f epo,
1013: ben_per_in_ler pil
1014: where ep.person_id=c_person_id
1015: and nvl(ep.pgm_id,-1)=c_pgm_id

Line 1029: from ben_elig_per_f ep,

1025: or
1026: pil.per_in_ler_stat_cd is null)
1027: union
1028: select prtn_strt_dt
1029: from ben_elig_per_f ep,
1030: ben_per_in_ler pil
1031: where ep.person_id=c_person_id
1032: and nvl(ep.pgm_id,-1)=c_pgm_id
1033: and ep.pl_id=c_pl_id