DBA Data[Home] [Help]

APPS.BEN_APR_BUS dependencies on BEN_ACTL_PREM_VRBL_RT_F

Line 1450: ben_actl_prem_vrbl_rt_f apv

1446: --
1447: cursor c1 is
1448: select vpf.mlt_cd, vpf.vrbl_rt_trtmt_cd
1449: from ben_vrbl_rt_prfl_f vpf,
1450: ben_actl_prem_vrbl_rt_f apv
1451: where apv.business_group_id +0 = p_business_group_id
1452: and vpf.business_group_id +0 = p_business_group_id
1453: and apv.actl_prem_id = p_actl_prem_id
1454: and vpf.vrbl_rt_prfl_id = apv.vrbl_rt_prfl_id

Line 2124: (p_base_table_name => 'ben_actl_prem_vrbl_rt_f',

2120: l_table_name := 'ben_oipl_f';
2121: Raise l_rows_exist;
2122: End If;
2123: If (dt_api.rows_exist
2124: (p_base_table_name => 'ben_actl_prem_vrbl_rt_f',
2125: p_base_key_column => 'actl_prem_id',
2126: p_base_key_value => p_actl_prem_id,
2127: p_from_date => p_validation_start_date,
2128: p_to_date => p_validation_end_date)) Then

Line 2129: l_table_name := 'ben_actl_prem_vrbl_rt_f';

2125: p_base_key_column => 'actl_prem_id',
2126: p_base_key_value => p_actl_prem_id,
2127: p_from_date => p_validation_start_date,
2128: p_to_date => p_validation_end_date)) Then
2129: l_table_name := 'ben_actl_prem_vrbl_rt_f';
2130: Raise l_rows_exist;
2131: End If;
2132: If (dt_api.rows_exist
2133: (p_base_table_name => 'ben_prtt_prem_f',