APPS.BEN_ABR_INS dependencies on BEN_PLIP_F

Line 84: from ben_plip_f

80: and p_effective_date between effective_start_date and effective_end_date;
81:
82: cursor c_plip is
83: select pl_id
84: from ben_plip_f
85: where plip_id = p_rec.plip_id
86: and p_effective_date between effective_start_date and effective_end_date;
87:
88: cursor c_oiplip is

Line 896: from ben_plip_f

892: l_oipl c_oipl%rowtype;
893: --
894: cursor c_plip is
895: select pgm_id, pl_id
896: from ben_plip_f
897: where plip_id = p_rec.plip_id
898: and p_effective_date between effective_start_date and effective_end_date;
899: --
900: l_plip c_plip%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 1289: p_parent_table_name9 => 'ben_plip_f',

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',
1291: p_parent_key_value9 => p_rec.plip_id,
1292: p_enforce_foreign_locking => true,
1293: p_validation_start_date => l_validation_start_date,

Line 1302: p_parent_table_name1 => 'ben_plip_f',

1298: p_datetrack_mode => p_datetrack_mode,
1299: p_base_table_name => 'ben_acty_base_rt_f',
1300: p_base_key_column => 'acty_base_rt_id',
1301: p_base_key_value => p_rec.acty_base_rt_id,
1302: p_parent_table_name1 => 'ben_plip_f',
1303: p_parent_key_column1 => 'plip_id',
1304: p_parent_key_value1 => p_rec.plip_id,
1305: p_parent_table_name2 => 'ben_pl_f',
1306: p_parent_key_column2 => 'pl_id',