APPS.BEN_DETERMINE_ELIGIBILITY2 dependencies on BEN_PLIP_F

Line 1354: from ben_plip_f cpp

1350: or pil.per_in_ler_stat_cd is null -- outer join condition
1351: );
1352: --
1353: cursor c_get_pl_id(c_effective_date date) is select pl_id
1354: from ben_plip_f cpp
1355: where cpp.plip_id = p_plip_id
1356: and c_effective_date
1357: between cpp.effective_start_date
1358: and cpp.effective_end_date;

Line 1426: select plip.ordr_num from ben_plip_f plip

1422: and v_wait_end_dt
1423: and ptl.business_group_id = p_business_group_id;
1424: --
1425: cursor c_plip_ordr(c_effective_date date ) is
1426: select plip.ordr_num from ben_plip_f plip
1427: where plip.pgm_id = nvl(p_pgm_id,l_envpgm_id)
1428: and pl_id = p_pl_id
1429: and c_effective_date
1430: between plip.effective_start_date