APPS.BEN_PLN_BUS dependencies on BEN_POPL_YR_PERD

Line 5107: from ben_popl_yr_perd t

5103: l_val number;
5104: --
5105: Cursor c_yr_perd_exists(p_pl_id in number ) Is
5106: select 1
5107: from ben_popl_yr_perd t
5108: where t.pl_id = p_pl_id ;
5109: --
5110: Cursor c_cwb_exists(p_pl_id in number ) Is
5111: select 1

Line 5393: (p_base_table_name => 'ben_popl_yr_perd',

5389: l_table_name := 'ben_bnft_rstrn_ctfn_f';
5390: Raise l_rows_exist;
5391: End If;
5392: /* If (dt_api.rows_exist -- Bug 4304937
5393: (p_base_table_name => 'ben_popl_yr_perd',
5394: p_base_key_column => 'pl_id',
5395: p_base_key_value => p_pl_id,
5396: p_from_date => p_validation_start_date,
5397: p_to_date => p_validation_end_date)) Then

Line 5398: l_table_name := 'ben_popl_yr_perd';

5394: p_base_key_column => 'pl_id',
5395: p_base_key_value => p_pl_id,
5396: p_from_date => p_validation_start_date,
5397: p_to_date => p_validation_end_date)) Then
5398: l_table_name := 'ben_popl_yr_perd';
5399: Raise l_rows_exist;
5400: End If;
5401: If (dt_api.rows_exist -- Bug 4304937
5402: (p_base_table_name => 'ben_cwb_wksht_grp',

Line 5417: l_table_name := 'ben_popl_yr_perd';

5413: fetch c_yr_perd_exists into l_val ;
5414: if c_yr_perd_exists%found
5415: then
5416: close c_yr_perd_exists;
5417: l_table_name := 'ben_popl_yr_perd';
5418: Raise l_rows_exist;
5419: end if;
5420: close c_yr_perd_exists;
5421: --