APPS.BEN_PLN_BUS dependencies on BEN_CWB_WKSHT_GRP

Line 5112: from ben_cwb_wksht_grp t

5108: where t.pl_id = p_pl_id ;
5109: --
5110: Cursor c_cwb_exists(p_pl_id in number ) Is
5111: select 1
5112: from ben_cwb_wksht_grp t
5113: where t.pl_id = p_pl_id ;
5114: --
5115: Begin
5116: hr_utility.set_location('Entering:'||l_proc, 5);

Line 5402: (p_base_table_name => 'ben_cwb_wksht_grp',

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',
5403: p_base_key_column => 'pl_id',
5404: p_base_key_value => p_pl_id,
5405: p_from_date => p_validation_start_date,
5406: p_to_date => p_validation_end_date)) Then

Line 5407: l_table_name := 'ben_cwb_wksht_grp';

5403: p_base_key_column => 'pl_id',
5404: p_base_key_value => p_pl_id,
5405: p_from_date => p_validation_start_date,
5406: p_to_date => p_validation_end_date)) Then
5407: l_table_name := 'ben_cwb_wksht_grp';
5408: Raise l_rows_exist;
5409: End If;
5410: */
5411: --

Line 5427: l_table_name := 'ben_cwb_wksht_grp';

5423: fetch c_cwb_exists into l_val ;
5424: if c_cwb_exists%found
5425: then
5426: close c_cwb_exists;
5427: l_table_name := 'ben_cwb_wksht_grp';
5428: Raise l_rows_exist;
5429: end if;
5430: close c_cwb_exists;
5431: --