DBA Data[Home] [Help]

APPS.BEN_DETERMINE_COMMUNICATIONS dependencies on BEN_PLIP_F

Line 1255: ben_plip_f plip

1251: select ptip.ptip_id,
1252: plip.plip_id
1253: from ben_pl_f pl,
1254: ben_ptip_f ptip,
1255: ben_plip_f plip
1256: where pl.pl_id = p_pl_id
1257: and pl.pl_typ_id = ptip.pl_typ_id
1258: and ptip.pgm_id = p_pgm_id
1259: and plip.pl_id = pl.pl_id

Line 1268: l_plip_id ben_plip_f.plip_id%type := null;

1264: plip.effective_start_date and plip.effective_end_date
1265: and g_parm.effective_date between
1266: ptip.effective_start_date and ptip.effective_end_date;
1267: --
1268: l_plip_id ben_plip_f.plip_id%type := null;
1269: l_ptip_id ben_ptip_f.ptip_id%type := null;
1270: l_pl_fctr_rec g_cache_pl_fctr_rec_type;
1271: l_plip_fctr_rec g_cache_plip_fctr_rec_type;
1272: l_return boolean := false;