DBA Data[Home] [Help]

APPS.BEN_ABR_BUS dependencies on BEN_VRBL_RT_RL_F

Line 1543: from ben_vrbl_rt_rl_f

1539: and business_group_id = p_business_group_id
1540: and p_effective_date between effective_start_date
1541: and effective_end_date
1542: UNION select null
1543: from ben_vrbl_rt_rl_f
1544: where acty_base_rt_id = p_acty_base_rt_id
1545: and business_group_id = p_business_group_id
1546: and p_effective_date between effective_start_date
1547: and effective_end_date;

Line 4817: (p_base_table_name => 'ben_vrbl_rt_rl_f',

4813: l_table_name := 'ben_aplcn_to_bnft_pool_f';
4814: Raise l_rows_exist;
4815: End If;
4816: If (dt_api.rows_exist
4817: (p_base_table_name => 'ben_vrbl_rt_rl_f',
4818: p_base_key_column => 'acty_base_rt_id',
4819: p_base_key_value => p_acty_base_rt_id,
4820: p_from_date => p_validation_start_date,
4821: p_to_date => p_validation_end_date)) Then

Line 4822: l_table_name := 'ben_vrbl_rt_rl_f';

4818: p_base_key_column => 'acty_base_rt_id',
4819: p_base_key_value => p_acty_base_rt_id,
4820: p_from_date => p_validation_start_date,
4821: p_to_date => p_validation_end_date)) Then
4822: l_table_name := 'ben_vrbl_rt_rl_f';
4823: Raise l_rows_exist;
4824: End If;
4825: If (dt_api.rows_exist
4826: (p_base_table_name => 'ben_comp_lvl_acty_rt_f',