DBA Data[Home] [Help]

APPS.BEN_DERIVE_PART_AND_RATE_FACTS dependencies on BEN_ELIG_TO_PRTE_RSN_F

Line 10241: FROM ben_elig_to_prte_rsn_f peo

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