APPS.BEN_CBS_BUS dependencies on BEN_ACTL_PREM_F

Line 296: -- p_actl_prem_id Foreign Key to BEN_ACTL_PREM_F

292: --
293: -- In Parameters
294: -- p_sgmt_num Sequence Number
295: -- p_prem_cstg_by_sgmt_id Primary Key
296: -- p_actl_prem_id Foreign Key to BEN_ACTL_PREM_F
297: -- p_business_group_id
298: --
299: -- Post Success
300: -- Processing continues

Line 373: select prem_asnmt_lvl_cd from ben_actl_prem_f a

369: l_api_updating boolean;
370: l_prem_asnmt_lvl_cd hr_lookups.lookup_code%TYPE; -- UTF8varchar2(30);
371: --
372: cursor c1 is
373: select prem_asnmt_lvl_cd from ben_actl_prem_f a
374: where a.business_group_id +0 = p_business_group_id
375: and a.actl_prem_id = p_actl_prem_id
376: and p_effective_date
377: between a.effective_start_date

Line 447: select a.prem_asnmt_cd,a.cost_allocation_keyflex_id from ben_actl_prem_f a

443: l_prem_asnmt_cd hr_lookups.lookup_code%TYPE; -- UTF8 varchar2(30);
444: l_cost_alloc_cd number(15);
445: --
446: cursor c1 is
447: select a.prem_asnmt_cd,a.cost_allocation_keyflex_id from ben_actl_prem_f a
448: where a.business_group_id +0 = p_business_group_id
449: and a.actl_prem_id = p_actl_prem_id
450: -- bug 5376303
451: and p_effective_date between a.effective_start_date

Line 559: (p_base_table_name => 'ben_actl_prem_f',

555: p_argument_value => p_validation_end_date);
556: --
557: If ((nvl(p_actl_prem_id, hr_api.g_number) <> hr_api.g_number) and
558: NOT (dt_api.check_min_max_dates
559: (p_base_table_name => 'ben_actl_prem_f',
560: p_base_key_column => 'actl_prem_id',
561: p_base_key_value => p_actl_prem_id,
562: p_from_date => p_validation_start_date,
563: p_to_date => p_validation_end_date))) Then

Line 564: l_table_name := 'ben_actl_prem_f';

560: p_base_key_column => 'actl_prem_id',
561: p_base_key_value => p_actl_prem_id,
562: p_from_date => p_validation_start_date,
563: p_to_date => p_validation_end_date))) Then
564: l_table_name := 'ben_actl_prem_f';
565: Raise l_integrity_error;
566: End If;
567: --
568: End If;