APPS.BEN_LEN_BUS dependencies on BEN_PL_F

Line 1338: ben_pl_f pln,

1334: cursor c_duplicate_ler is
1335: select 1
1336: from
1337: ben_popl_enrt_typ_cycl_f pet,
1338: ben_pl_f pln,
1339: ben_lee_rsn_f len1,
1340: ben_popl_enrt_typ_cycl_f pet1,
1341: ben_pl_f pln1
1342: where

Line 1341: ben_pl_f pln1

1337: ben_popl_enrt_typ_cycl_f pet,
1338: ben_pl_f pln,
1339: ben_lee_rsn_f len1,
1340: ben_popl_enrt_typ_cycl_f pet1,
1341: ben_pl_f pln1
1342: where
1343: pet.popl_enrt_typ_cycl_id = p_popl_enrt_typ_cycl_id
1344: and p_effective_date between pet.effective_start_date
1345: and pet.effective_end_date

Line 1425: from ben_pl_f pln

1421: ) is
1422: --
1423: cursor c_pl_cd is
1424: select pln.pl_cd
1425: from ben_pl_f pln
1426: ,ben_popl_enrt_typ_cycl_f pet
1427: where pet.popl_enrt_typ_cycl_id = p_popl_enrt_typ_cycl_id
1428: and pet.pl_id = pln.pl_id
1429: and pln.business_group_id = p_business_group_id

Line 1434: l_pl_cd ben_pl_f.pl_cd%TYPE;

1430: and pet.business_group_id = pln.business_group_id
1431: and p_effective_date between pln.effective_start_date and pln.effective_end_date
1432: and p_effective_date between pet.effective_start_date and pet.effective_end_date;
1433: --
1434: l_pl_cd ben_pl_f.pl_cd%TYPE;
1435: l_api_updating boolean;
1436: l_proc varchar2(72) := g_package||'chk_defer_flag_set_pln_plip';
1437: --
1438: begin