DBA Data[Home] [Help]

APPS.BEN_DETERMINE_RATES dependencies on BEN_ELIG_PER_F

Line 1961: FROM ben_elig_per_f ep, ben_per_in_ler pil

1957: ep.rt_age_val,
1958: ep.rt_los_val,
1959: ep.rt_hrs_wkd_val,
1960: ep.rt_cmbn_age_n_los_val
1961: FROM ben_elig_per_f ep, ben_per_in_ler pil
1962: WHERE ep.person_id = c_person_id
1963: AND ep.pgm_id IS NULL
1964: AND ep.pl_id = c_pl_id
1965: AND c_effective_date BETWEEN ep.effective_start_date

Line 1983: FROM ben_elig_per_f ep, ben_elig_per_opt_f epo, ben_per_in_ler pil

1979: epo.rt_age_val,
1980: epo.rt_los_val,
1981: epo.rt_hrs_wkd_val,
1982: epo.rt_cmbn_age_n_los_val
1983: FROM ben_elig_per_f ep, ben_elig_per_opt_f epo, ben_per_in_ler pil
1984: WHERE ep.person_id = c_person_id
1985: AND ep.pgm_id IS NULL
1986: AND ep.pl_id = c_pl_id
1987: AND epo.opt_id = c_opt_id