DBA Data[Home] [Help]

APPS.BEN_DETERMINE_COMMUNICATIONS dependencies on BEN_PLIP_F

Line 1259: ben_plip_f plip

1255: select ptip.ptip_id,
1256: plip.plip_id
1257: from ben_pl_f pl,
1258: ben_ptip_f ptip,
1259: ben_plip_f plip
1260: where pl.pl_id = p_pl_id
1261: and pl.pl_typ_id = ptip.pl_typ_id
1262: and ptip.pgm_id = p_pgm_id
1263: and plip.pl_id = pl.pl_id

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

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