APPS.BEN_ABR_BUS dependencies on BEN_OPT_F

Line 3727: From pay_grade_rules_f a , pay_rates b , per_spinal_points c,ben_opt_f opt

3723: l_dummy varchar2(1);
3724: --
3725: cursor c2 is
3726: select 'x'
3727: From pay_grade_rules_f a , pay_rates b , per_spinal_points c,ben_opt_f opt
3728: where a.grade_rule_id = p_pay_rate_grade_rule_id
3729: and a.rate_id = b.rate_id
3730: and a.rate_type = 'SP'
3731: and c.spinal_point_id = a.grade_or_spinal_point_id

Line 4556: (p_base_table_name => 'ben_opt_f',

4552: Raise l_integrity_error;
4553: End If;
4554: If ((nvl(p_opt_id, hr_api.g_number) <> hr_api.g_number) and
4555: NOT (dt_api.check_min_max_dates
4556: (p_base_table_name => 'ben_opt_f',
4557: p_base_key_column => 'opt_id',
4558: p_base_key_value => p_opt_id,
4559: p_from_date => p_validation_start_date,
4560: p_to_date => p_validation_end_date))) Then

Line 4561: l_table_name := 'ben_opt_f';

4557: p_base_key_column => 'opt_id',
4558: p_base_key_value => p_opt_id,
4559: p_from_date => p_validation_start_date,
4560: p_to_date => p_validation_end_date))) Then
4561: l_table_name := 'ben_opt_f';
4562: Raise l_integrity_error;
4563: End If;
4564: If ((nvl(p_oiplip_id, hr_api.g_number) <> hr_api.g_number) and
4565: NOT (dt_api.check_min_max_dates