APPS.BEN_PLN_BUS dependencies on BEN_OIPL_F

Line 514: from ben_oipl_f cop

510: l_dummy_c1 varchar2(1);
511: --
512: cursor c1 is
513: select null
514: from ben_oipl_f cop
515: where cop.pl_id=p_pl_id
516: and cop.auto_enrt_flag = 'Y'
517: and p_effective_date between cop.effective_start_date
518: and cop.effective_end_date

Line 4472: from ben_oipl_f a

4468: l_dummy varchar2(1);
4469: --
4470: cursor c1 is
4471: select null
4472: from ben_oipl_f a
4473: where a.business_group_id +0 = p_business_group_id
4474: and a.actl_prem_id = p_actl_prem_id
4475: and p_effective_date
4476: between a.effective_start_date

Line 5159: (p_base_table_name => 'ben_oipl_f',

5155: l_table_name := 'ben_pl_regy_bod_f';
5156: Raise l_rows_exist;
5157: End If;
5158: If (dt_api.rows_exist
5159: (p_base_table_name => 'ben_oipl_f',
5160: p_base_key_column => 'pl_id',
5161: p_base_key_value => p_pl_id,
5162: p_from_date => p_validation_start_date,
5163: p_to_date => p_validation_end_date)) Then

Line 5164: l_table_name := 'ben_oipl_f';

5160: p_base_key_column => 'pl_id',
5161: p_base_key_value => p_pl_id,
5162: p_from_date => p_validation_start_date,
5163: p_to_date => p_validation_end_date)) Then
5164: l_table_name := 'ben_oipl_f';
5165: Raise l_rows_exist;
5166: End If;
5167: If (dt_api.rows_exist
5168: (p_base_table_name => 'ben_popl_enrt_typ_cycl_f',