APPS.BEN_ABR_INS dependencies on BEN_OIPLIP_F

Line 90: from ben_oiplip_f opp,

86: and p_effective_date between effective_start_date and effective_end_date;
87:
88: cursor c_oiplip is
89: select pl_id
90: from ben_oiplip_f opp,
91: ben_oipl_f op
92: where opp.oiplip_id = p_rec.oiplip_id
93: and opp.oipl_id = op.oipl_id
94: and p_effective_date between opp.effective_start_date and opp.effective_end_date

Line 904: from ben_oiplip_f oiplip, ben_oipl_f oipl, ben_plip_f plip

900: l_plip c_plip%rowtype;
901: --
902: cursor c_oiplip is
903: select plip.pgm_id, oipl.pl_id, oipl.opt_id
904: from ben_oiplip_f oiplip, ben_oipl_f oipl, ben_plip_f plip
905: where oiplip.oiplip_id = p_rec.oiplip_id
906: and oiplip.oipl_id = oipl.oipl_id
907: and oiplip.plip_id = plip.plip_id
908: and oipl.pl_id = plip.pl_id

Line 1311: p_parent_table_name4 => 'ben_oiplip_f',

1307: p_parent_key_value2 => p_rec.pl_id,
1308: p_parent_table_name3 => 'ben_acty_base_rt_f',
1309: p_parent_key_column3 => 'acty_base_rt_id',
1310: p_parent_key_value3 => p_rec.parnt_acty_base_rt_id,
1311: p_parent_table_name4 => 'ben_oiplip_f',
1312: p_parent_key_column4 => 'oiplip_id',
1313: p_parent_key_value4 => p_rec.oiplip_id,
1314: p_parent_table_name5 => 'ben_actl_prem_f',
1315: p_parent_key_column5 => 'actl_prem_id',