APPS.BEN_ABR_INS dependencies on BEN_PL_F

Line 100: ben_pl_f pln

96:
97: cursor c_pl_typ(p_pl_id number) is
98: select opt_typ_cd
99: from ben_pl_typ_f ptp,
100: ben_pl_f pln
101: where pln.pl_id = p_pl_id
102: and ptp.pl_typ_id = pln.pl_typ_id
103: and p_effective_date between pln.effective_start_date and pln.effective_end_date
104: and p_effective_date between ptp.effective_start_date and ptp.effective_end_date;

Line 1305: p_parent_table_name2 => 'ben_pl_f',

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',
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',