APPS.BEN_LDC_BUS dependencies on FF_FORMULAS_F

Line 208: from ff_formulas_f ff

204: l_dummy varchar2(1);
205: --
206: cursor c1 is
207: select null
208: from ff_formulas_f ff
209: ,per_business_groups pbg
210: where ff.formula_id = p_cvg_eff_end_rl
211: and ff.formula_type_id = -28 --Dependent Coverage End
212: and pbg.business_group_id = p_business_group_id

Line 301: from ff_formulas_f ff

297: l_dummy varchar2(1);
298: --
299: cursor c1 is
300: select null
301: from ff_formulas_f ff
302: ,per_business_groups pbg
303: where ff.formula_id = p_cvg_eff_strt_rl
304: and ff.formula_type_id = -27 --Dependent Coverage Start
305: and pbg.business_group_id = p_business_group_id

Line 394: from ff_formulas_f ff

390: l_dummy varchar2(1);
391: --
392: cursor c1 is
393: select null
394: from ff_formulas_f ff
395: ,per_business_groups pbg
396: where ff.formula_id = p_ler_chg_dpnt_cvg_rl
397: and ff.formula_type_id = -36 --Change Dependent Coverage
398: and pbg.business_group_id = p_business_group_id

Line 1140: (p_base_table_name => 'ff_formulas_f',

1136: p_argument_value => p_validation_end_date);
1137: --
1138: If ((nvl(p_ler_chg_dpnt_cvg_rl, hr_api.g_number) <> hr_api.g_number) and
1139: NOT (dt_api.check_min_max_dates
1140: (p_base_table_name => 'ff_formulas_f',
1141: p_base_key_column => 'formula_id',
1142: p_base_key_value => p_ler_chg_dpnt_cvg_rl,
1143: p_from_date => p_validation_start_date,
1144: p_to_date => p_validation_end_date))) Then

Line 1145: l_table_name := 'ff_formulas_f';

1141: p_base_key_column => 'formula_id',
1142: p_base_key_value => p_ler_chg_dpnt_cvg_rl,
1143: p_from_date => p_validation_start_date,
1144: p_to_date => p_validation_end_date))) Then
1145: l_table_name := 'ff_formulas_f';
1146: Raise l_integrity_error;
1147: End If;
1148: If ((nvl(p_cvg_eff_strt_rl, hr_api.g_number) <> hr_api.g_number) and
1149: NOT (dt_api.check_min_max_dates

Line 1150: (p_base_table_name => 'ff_formulas_f',

1146: Raise l_integrity_error;
1147: End If;
1148: If ((nvl(p_cvg_eff_strt_rl, hr_api.g_number) <> hr_api.g_number) and
1149: NOT (dt_api.check_min_max_dates
1150: (p_base_table_name => 'ff_formulas_f',
1151: p_base_key_column => 'formula_id',
1152: p_base_key_value => p_cvg_eff_strt_rl,
1153: p_from_date => p_validation_start_date,
1154: p_to_date => p_validation_end_date))) Then

Line 1155: l_table_name := 'ff_formulas_f';

1151: p_base_key_column => 'formula_id',
1152: p_base_key_value => p_cvg_eff_strt_rl,
1153: p_from_date => p_validation_start_date,
1154: p_to_date => p_validation_end_date))) Then
1155: l_table_name := 'ff_formulas_f';
1156: Raise l_integrity_error;
1157: End If;
1158: If ((nvl(p_cvg_eff_end_rl, hr_api.g_number) <> hr_api.g_number) and
1159: NOT (dt_api.check_min_max_dates

Line 1160: (p_base_table_name => 'ff_formulas_f',

1156: Raise l_integrity_error;
1157: End If;
1158: If ((nvl(p_cvg_eff_end_rl, hr_api.g_number) <> hr_api.g_number) and
1159: NOT (dt_api.check_min_max_dates
1160: (p_base_table_name => 'ff_formulas_f',
1161: p_base_key_column => 'formula_id',
1162: p_base_key_value => p_cvg_eff_end_rl,
1163: p_from_date => p_validation_start_date,
1164: p_to_date => p_validation_end_date))) Then

Line 1165: l_table_name := 'ff_formulas_f';

1161: p_base_key_column => 'formula_id',
1162: p_base_key_value => p_cvg_eff_end_rl,
1163: p_from_date => p_validation_start_date,
1164: p_to_date => p_validation_end_date))) Then
1165: l_table_name := 'ff_formulas_f';
1166: Raise l_integrity_error;
1167: End If;
1168: If ((nvl(p_ptip_id, hr_api.g_number) <> hr_api.g_number) and
1169: NOT (dt_api.check_min_max_dates