DBA Data[Home] [Help]

APPS.BEN_EPA_BUS dependencies on FF_FORMULAS_F

Line 285: from ff_formulas_f ff ,

281: l_dummy varchar2(1);
282: --
283: cursor c1 is
284: select null
285: from ff_formulas_f ff ,
286: per_business_groups pbg
287: where ff.formula_id = p_prtn_eff_end_dt_rl
288: and ff.formula_type_id = -83
289: and nvl(ff.business_group_id, p_business_group_id) =

Line 381: from ff_formulas_f ff ,

377: l_dummy varchar2(1);
378: --
379: cursor c1 is
380: select null
381: from ff_formulas_f ff ,
382: per_business_groups pbg
383: where ff.formula_id = p_prtn_eff_strt_dt_rl
384: and ff.formula_type_id = -82
385: and nvl(ff.business_group_id, p_business_group_id) =

Line 1811: (p_base_table_name => 'ff_formulas_f',

1807: p_argument_value => p_validation_end_date);
1808: --
1809: If ((nvl(p_prtn_eff_end_dt_rl, hr_api.g_number) <> hr_api.g_number) and
1810: NOT (dt_api.check_min_max_dates
1811: (p_base_table_name => 'ff_formulas_f',
1812: p_base_key_column => 'formula_id',
1813: p_base_key_value => p_prtn_eff_end_dt_rl,
1814: p_from_date => p_validation_start_date,
1815: p_to_date => p_validation_end_date))) Then

Line 1816: l_table_name := 'ff_formulas_f';

1812: p_base_key_column => 'formula_id',
1813: p_base_key_value => p_prtn_eff_end_dt_rl,
1814: p_from_date => p_validation_start_date,
1815: p_to_date => p_validation_end_date))) Then
1816: l_table_name := 'ff_formulas_f';
1817: Raise l_integrity_error;
1818: End If;
1819: If ((nvl(p_oipl_id, hr_api.g_number) <> hr_api.g_number) and
1820: NOT (dt_api.check_min_max_dates