APPS.BEN_AVR_BUS dependencies on BEN_VRBL_RT_PRFL_F

Line 370: cursor c2 is select null from ben_vrbl_rt_prfl_f where

366: and abr.business_group_id=p_business_group_id
367: and abr.rt_usg_cd='IMPTDINC'
368: and p_effective_date between effective_start_date and effective_end_date;
369:
370: cursor c2 is select null from ben_vrbl_rt_prfl_f where
371: vrbl_rt_prfl_id=p_vrbl_rt_prfl_id
372: and business_group_id=p_business_group_id
373: and p_effective_date between effective_start_date and effective_end_date
374: and mlt_cd in ('FLFX' , 'RL' ) and VRBL_RT_TRTMT_CD ='RPLC';

Line 554: (p_base_table_name => 'ben_vrbl_rt_prfl_f',

550: Raise l_integrity_error;
551: End If;
552: If ((nvl(p_vrbl_rt_prfl_id, hr_api.g_number) <> hr_api.g_number) and
553: NOT (dt_api.check_min_max_dates
554: (p_base_table_name => 'ben_vrbl_rt_prfl_f',
555: p_base_key_column => 'vrbl_rt_prfl_id',
556: p_base_key_value => p_vrbl_rt_prfl_id,
557: p_from_date => p_validation_start_date,
558: p_to_date => p_validation_end_date))) Then

Line 559: l_table_name := 'ben_vrbl_rt_prfl_f';

555: p_base_key_column => 'vrbl_rt_prfl_id',
556: p_base_key_value => p_vrbl_rt_prfl_id,
557: p_from_date => p_validation_start_date,
558: p_to_date => p_validation_end_date))) Then
559: l_table_name := 'ben_vrbl_rt_prfl_f';
560: Raise l_integrity_error;
561: End If;
562: --
563: End If;