DBA Data[Home] [Help]

APPS.BEN_DERIVE_PART_AND_RATE_FACTS dependencies on BEN_ELIG_TO_PRTE_RSN_F

Line 10240: FROM ben_elig_to_prte_rsn_f peo

10236: p_ler_id IN NUMBER
10237: ,p_pgm_id IN NUMBER
10238: ,p_ptip_id IN NUMBER) IS
10239: SELECT peo.*
10240: FROM ben_elig_to_prte_rsn_f peo
10241: WHERE peo.ler_id = p_ler_id
10242: AND peo.business_group_id = p_business_group_id
10243: AND NVL(p_lf_evt_ocrd_dt
10244: ,p_effective_date) BETWEEN peo.effective_start_date