APPS.BEN_TCV_BUS dependencies on BEN_VRBL_RT_PRFL_F

Line 175: from ben_vrbl_rt_prfl_f

171:
172:
173:
174: cursor c1 is select vrbl_usg_cd, mlt_cd
175: from ben_vrbl_rt_prfl_f
176: where vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
177: and p_effective_date between effective_start_date
178: and effective_end_date
179: and business_group_id = p_business_group_id;

Line 589: -- the ARC relationship on ben_vrbl_rt_prfl_f.

585: --
586: -- Description
587: -- This procedure is used to check that the cvg_vol is mutually exclusive for
588: -- vrbl_rt_prfl_id. A ttl_prtt_rt cannot exist with this vrbl_rt_prfl_id due t
589: -- the ARC relationship on ben_vrbl_rt_prfl_f.
590: --
591: -- Pre Conditions
592: -- None.
593: --

Line 915: (p_base_table_name => 'ben_vrbl_rt_prfl_f',

911: p_argument_value => p_validation_end_date);
912: --
913: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and
914: NOT (dt_api.check_min_max_dates
915: (p_base_table_name => 'ben_vrbl_rt_prfl_f',
916: p_base_key_column => 'vrbl_rt_prfl_id',
917: p_base_key_value => p_vrbl_rt_prfl_id,
918: p_from_date => p_validation_start_date,
919: p_to_date => p_validation_end_date))) Then

Line 920: l_table_name := 'ben_vrbl_rt_prfl_f';

916: p_base_key_column => 'vrbl_rt_prfl_id',
917: p_base_key_value => p_vrbl_rt_prfl_id,
918: p_from_date => p_validation_start_date,
919: p_to_date => p_validation_end_date))) Then
920: l_table_name := 'ben_vrbl_rt_prfl_f';
921: Raise l_integrity_error;
922: End If;
923: --
924: End If;