DBA Data[Home] [Help]

APPS.BEN_DETERMINE_COMMUNICATIONS dependencies on BEN_PTIP_F

Line 1258: ben_ptip_f ptip,

1254: cursor c_get_pl_details is
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

Line 1273: l_ptip_id ben_ptip_f.ptip_id%type := null;

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;
1277: l_proc varchar2(80) := g_package || '.fctr_belongs_to_comp_object';