DBA Data[Home] [Help]

APPS.BEN_DETERMINE_RATES dependencies on BEN_ELIG_PER_F

Line 1963: FROM ben_elig_per_f ep, ben_per_in_ler pil

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

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

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