DBA Data[Home] [Help]

APPS.BEN_PCT_BUS dependencies on FF_FORMULAS_F

Line 117: from ff_formulas_f ff,

113: l_dummy varchar2(1);
114: --
115: cursor c1 is
116: select null
117: from ff_formulas_f ff,
118: per_business_groups pbg
119: where ff.formula_id = p_ctfn_rqd_when_rl
120: and ff.formula_type_id = -43 -- BEN_LACK_CTFN_DENY_RMBMT
121: and pbg.business_group_id = p_business_group_id

Line 448: (p_base_table_name => 'ff_formulas_f',

444: p_argument_value => p_validation_end_date);
445: --
446: If ((nvl(p_ctfn_rqd_when_rl, hr_api.g_number) <> hr_api.g_number) and
447: NOT (dt_api.check_min_max_dates
448: (p_base_table_name => 'ff_formulas_f',
449: p_base_key_column => 'formula_id',
450: p_base_key_value => p_ctfn_rqd_when_rl,
451: p_from_date => p_validation_start_date,
452: p_to_date => p_validation_end_date))) Then

Line 453: l_table_name := 'ff_formulas_f';

449: p_base_key_column => 'formula_id',
450: p_base_key_value => p_ctfn_rqd_when_rl,
451: p_from_date => p_validation_start_date,
452: p_to_date => p_validation_end_date))) Then
453: l_table_name := 'ff_formulas_f';
454: Raise l_integrity_error;
455: End If;
456: If ((nvl(p_pl_gd_or_svc_id, hr_api.g_number) <> hr_api.g_number) and
457: NOT (dt_api.check_min_max_dates