APPS.BEN_ABR_INS dependencies on BEN_OIPL_F

Line 78: from ben_oipl_f

74:
75: --Added for Bug 6881417
76: cursor c_oipl is
77: select pl_id
78: from ben_oipl_f
79: where oipl_id = p_rec.oipl_id
80: and p_effective_date between effective_start_date and effective_end_date;
81:
82: cursor c_plip is

Line 91: ben_oipl_f op

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
95: and p_effective_date between op.effective_start_date and op.effective_end_date;

Line 888: from ben_oipl_f

884: from sys.dual;
885: --
886: cursor c_oipl is
887: select opt_id, pl_id
888: from ben_oipl_f
889: where oipl_id = p_rec.oipl_id
890: and p_effective_date between effective_start_date and effective_end_date;
891: --
892: l_oipl c_oipl%rowtype;

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 1286: p_parent_table_name8 => 'ben_oipl_f',

1282: p_parent_key_value6 => p_rec.pgm_id,
1283: p_parent_table_name7 => 'ben_ptip_f',
1284: p_parent_key_column7 => 'ptip_id',
1285: p_parent_key_value7 => p_rec.ptip_id,
1286: p_parent_table_name8 => 'ben_oipl_f',
1287: p_parent_key_column8 => 'oipl_id',
1288: p_parent_key_value8 => p_rec.oipl_id,
1289: p_parent_table_name9 => 'ben_plip_f',
1290: p_parent_key_column9 => 'plip_id',