eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_ABR_BUS dependencies on FF_FORMULAS_F

Line 1087: from ff_formulas_f ff

1083: --
1084:
1085: cursor c1(p_rule number, p_formula_type_id in number) is
1086: select null
1087: from ff_formulas_f ff
1088: ,per_business_groups pbg
1089: where ff.formula_id = p_rule
1090: and ff.formula_type_id = p_formula_type_id
1091: and pbg.business_group_id = p_business_group_id

Line 4436: (p_base_table_name => 'ff_formulas_f',

4432: p_argument_value => p_validation_end_date);
4433: --
4434: If ((nvl(p_prtl_mo_det_mthd_rl, hr_api.g_number) <> hr_api.g_number) and
4435: NOT (dt_api.check_min_max_dates
4436: (p_base_table_name => 'ff_formulas_f',
4437: p_base_key_column => 'formula_id',
4438: p_base_key_value => p_prtl_mo_det_mthd_rl,
4439: p_from_date => p_validation_start_date,
4440: p_to_date => p_validation_end_date))) Then

Line 4441: l_table_name := 'ff_formulas_f';

4437: p_base_key_column => 'formula_id',
4438: p_base_key_value => p_prtl_mo_det_mthd_rl,
4439: p_from_date => p_validation_start_date,
4440: p_to_date => p_validation_end_date))) Then
4441: l_table_name := 'ff_formulas_f';
4442: Raise l_integrity_error;
4443: End If;
4444: If ((nvl(p_prtl_mo_eff_dt_det_rl, hr_api.g_number) <> hr_api.g_number) and
4445: NOT (dt_api.check_min_max_dates

Line 4446: (p_base_table_name => 'ff_formulas_f',

4442: Raise l_integrity_error;
4443: End If;
4444: If ((nvl(p_prtl_mo_eff_dt_det_rl, hr_api.g_number) <> hr_api.g_number) and
4445: NOT (dt_api.check_min_max_dates
4446: (p_base_table_name => 'ff_formulas_f',
4447: p_base_key_column => 'formula_id',
4448: p_base_key_value => p_prtl_mo_eff_dt_det_rl,
4449: p_from_date => p_validation_start_date,
4450: p_to_date => p_validation_end_date))) Then

Line 4451: l_table_name := 'ff_formulas_f';

4447: p_base_key_column => 'formula_id',
4448: p_base_key_value => p_prtl_mo_eff_dt_det_rl,
4449: p_from_date => p_validation_start_date,
4450: p_to_date => p_validation_end_date))) Then
4451: l_table_name := 'ff_formulas_f';
4452: Raise l_integrity_error;
4453: End If;
4454: If ((nvl(p_rndg_rl, hr_api.g_number) <> hr_api.g_number) and
4455: NOT (dt_api.check_min_max_dates

Line 4456: (p_base_table_name => 'ff_formulas_f',

4452: Raise l_integrity_error;
4453: End If;
4454: If ((nvl(p_rndg_rl, hr_api.g_number) <> hr_api.g_number) and
4455: NOT (dt_api.check_min_max_dates
4456: (p_base_table_name => 'ff_formulas_f',
4457: p_base_key_column => 'formula_id',
4458: p_base_key_value => p_rndg_rl,
4459: p_from_date => p_validation_start_date,
4460: p_to_date => p_validation_end_date))) Then

Line 4461: l_table_name := 'ff_formulas_f';

4457: p_base_key_column => 'formula_id',
4458: p_base_key_value => p_rndg_rl,
4459: p_from_date => p_validation_start_date,
4460: p_to_date => p_validation_end_date))) Then
4461: l_table_name := 'ff_formulas_f';
4462: Raise l_integrity_error;
4463: End If;
4464: If ((nvl(p_lwr_lmt_calc_rl, hr_api.g_number) <> hr_api.g_number) and
4465: NOT (dt_api.check_min_max_dates

Line 4466: (p_base_table_name => 'ff_formulas_f',

4462: Raise l_integrity_error;
4463: End If;
4464: If ((nvl(p_lwr_lmt_calc_rl, hr_api.g_number) <> hr_api.g_number) and
4465: NOT (dt_api.check_min_max_dates
4466: (p_base_table_name => 'ff_formulas_f',
4467: p_base_key_column => 'formula_id',
4468: p_base_key_value => p_lwr_lmt_calc_rl,
4469: p_from_date => p_validation_start_date,
4470: p_to_date => p_validation_end_date))) Then

Line 4471: l_table_name := 'ff_formulas_f';

4467: p_base_key_column => 'formula_id',
4468: p_base_key_value => p_lwr_lmt_calc_rl,
4469: p_from_date => p_validation_start_date,
4470: p_to_date => p_validation_end_date))) Then
4471: l_table_name := 'ff_formulas_f';
4472: Raise l_integrity_error;
4473: End If;
4474: If ((nvl(p_upr_lmt_calc_rl, hr_api.g_number) <> hr_api.g_number) and
4475: NOT (dt_api.check_min_max_dates

Line 4476: (p_base_table_name => 'ff_formulas_f',

4472: Raise l_integrity_error;
4473: End If;
4474: If ((nvl(p_upr_lmt_calc_rl, hr_api.g_number) <> hr_api.g_number) and
4475: NOT (dt_api.check_min_max_dates
4476: (p_base_table_name => 'ff_formulas_f',
4477: p_base_key_column => 'formula_id',
4478: p_base_key_value => p_upr_lmt_calc_rl,
4479: p_from_date => p_validation_start_date,
4480: p_to_date => p_validation_end_date))) Then

Line 4481: l_table_name := 'ff_formulas_f';

4477: p_base_key_column => 'formula_id',
4478: p_base_key_value => p_upr_lmt_calc_rl,
4479: p_from_date => p_validation_start_date,
4480: p_to_date => p_validation_end_date))) Then
4481: l_table_name := 'ff_formulas_f';
4482: Raise l_integrity_error;
4483: End If;
4484: If ((nvl(p_val_calc_rl, hr_api.g_number) <> hr_api.g_number) and
4485: NOT (dt_api.check_min_max_dates

Line 4486: (p_base_table_name => 'ff_formulas_f',

4482: Raise l_integrity_error;
4483: End If;
4484: If ((nvl(p_val_calc_rl, hr_api.g_number) <> hr_api.g_number) and
4485: NOT (dt_api.check_min_max_dates
4486: (p_base_table_name => 'ff_formulas_f',
4487: p_base_key_column => 'formula_id',
4488: p_base_key_value => p_val_calc_rl,
4489: p_from_date => p_validation_start_date,
4490: p_to_date => p_validation_end_date))) Then

Line 4491: l_table_name := 'ff_formulas_f';

4487: p_base_key_column => 'formula_id',
4488: p_base_key_value => p_val_calc_rl,
4489: p_from_date => p_validation_start_date,
4490: p_to_date => p_validation_end_date))) Then
4491: l_table_name := 'ff_formulas_f';
4492: Raise l_integrity_error;
4493: End If;
4494: If ((nvl(p_vstg_for_acty_rt_id, hr_api.g_number) <> hr_api.g_number) and
4495: NOT (dt_api.check_min_max_dates

Line 4609: (p_base_table_name => 'ff_formulas_f',

4605: End If;
4606: --
4607: If ((nvl(p_input_va_calc_rl, hr_api.g_number) <> hr_api.g_number) and
4608: NOT (dt_api.check_min_max_dates
4609: (p_base_table_name => 'ff_formulas_f',
4610: p_base_key_column => 'formula_id',
4611: p_base_key_value => p_input_va_calc_rl,
4612: p_from_date => p_validation_start_date,
4613: p_to_date => p_validation_end_date))) Then

Line 4614: l_table_name := 'ff_formulas_f';

4610: p_base_key_column => 'formula_id',
4611: p_base_key_value => p_input_va_calc_rl,
4612: p_from_date => p_validation_start_date,
4613: p_to_date => p_validation_end_date))) Then
4614: l_table_name := 'ff_formulas_f';
4615: Raise l_integrity_error;
4616: End If;
4617: --
4618: If ((nvl(p_element_det_rl, hr_api.g_number) <> hr_api.g_number) and

Line 4620: (p_base_table_name => 'ff_formulas_f',

4616: End If;
4617: --
4618: If ((nvl(p_element_det_rl, hr_api.g_number) <> hr_api.g_number) and
4619: NOT (dt_api.check_min_max_dates
4620: (p_base_table_name => 'ff_formulas_f',
4621: p_base_key_column => 'formula_id',
4622: p_base_key_value => p_element_det_rl,
4623: p_from_date => p_validation_start_date,
4624: p_to_date => p_validation_end_date))) Then

Line 4625: l_table_name := 'ff_formulas_f';

4621: p_base_key_column => 'formula_id',
4622: p_base_key_value => p_element_det_rl,
4623: p_from_date => p_validation_start_date,
4624: p_to_date => p_validation_end_date))) Then
4625: l_table_name := 'ff_formulas_f';
4626: Raise l_integrity_error;
4627: End If;
4628: --
4629: