APPS.BEN_EEI_BUS dependencies on BEN_OIPL_F

Line 121: from ben_oipl_f cop

117: l_exists varchar2(1);
118: --
119: cursor c1 is
120: select null
121: from ben_oipl_f cop
122: where cop.oipl_id = p_oipl_id
123: and cop.business_group_id = p_business_group_id
124: and p_effective_date
125: between cop.effective_start_date and cop.effective_end_date;

Line 468: (p_base_table_name => 'ben_oipl_f',

464: Raise l_integrity_error;
465: End If;
466: If ((nvl(p_oipl_id, hr_api.g_number) <> hr_api.g_number) and
467: NOT (dt_api.check_min_max_dates
468: (p_base_table_name => 'ben_oipl_f',
469: p_base_key_column => 'oipl_id',
470: p_base_key_value => p_oipl_id,
471: p_from_date => p_validation_start_date,
472: p_to_date => p_validation_end_date))) Then

Line 473: l_table_name := 'ben_oipl_f';

469: p_base_key_column => 'oipl_id',
470: p_base_key_value => p_oipl_id,
471: p_from_date => p_validation_start_date,
472: p_to_date => p_validation_end_date))) Then
473: l_table_name := 'ben_oipl_f';
474: Raise l_integrity_error;
475: End If;
476: --
477: End If;