DBA Data[Home] [Help]

APPS.BEN_ABR_BUS dependencies on BEN_ACTL_PREM_F

Line 3508: from ben_actl_prem_f

3504: l_proc varchar2(72) := g_package||'chk_actual_premium_asnmt_cd';
3505: l_dummy char(1);
3506: --
3507: cursor c1 is select null
3508: from ben_actl_prem_f
3509: where actl_prem_id = p_actl_prem_id
3510: and prem_asnmt_cd = 'PROC'
3511: and business_group_id = p_business_group_id
3512: and p_effective_date between effective_start_date

Line 4506: (p_base_table_name => 'ben_actl_prem_f',

4502: Raise l_integrity_error;
4503: End If;
4504: If ((nvl(p_actl_prem_id, hr_api.g_number) <> hr_api.g_number) and
4505: NOT (dt_api.check_min_max_dates
4506: (p_base_table_name => 'ben_actl_prem_f',
4507: p_base_key_column => 'actl_prem_id',
4508: p_base_key_value => p_actl_prem_id,
4509: p_from_date => p_validation_start_date,
4510: p_to_date => p_validation_end_date))) Then