APPS.BEN_DETERMINE_ELIGIBILITY2 dependencies on BEN_PLIP_F

Line 1341: from ben_plip_f cpp

1337: or pil.per_in_ler_stat_cd is null -- outer join condition
1338: );
1339: --
1340: cursor c_get_pl_id(c_effective_date date) is select pl_id
1341: from ben_plip_f cpp
1342: where cpp.plip_id = p_plip_id
1343: and c_effective_date
1344: between cpp.effective_start_date
1345: and cpp.effective_end_date;

Line 1413: select plip.ordr_num from ben_plip_f plip

1409: and v_wait_end_dt
1410: and ptl.business_group_id = p_business_group_id;
1411: --
1412: cursor c_plip_ordr(c_effective_date date ) is
1413: select plip.ordr_num from ben_plip_f plip
1414: where plip.pgm_id = nvl(p_pgm_id,l_envpgm_id)
1415: and pl_id = p_pl_id
1416: and c_effective_date
1417: between plip.effective_start_date