APPS.BEN_ABR_BUS dependencies on BEN_PGM_F

Line 3579: from ben_pgm_f

3575: is
3576: l_proc varchar2(72) := g_package||' chk_pgm_typ_code ';
3577: l_dummy char(1);
3578: cursor c1 is select null
3579: from ben_pgm_f
3580: where pgm_id = p_pgm_id
3581: and (pgm_typ_cd = 'FLEX' or pgm_typ_cd = 'FPC')
3582: and business_group_id = p_business_group_id
3583: and p_effective_date between effective_start_date

Line 3587: from ben_pgm_f a, ben_ptip_f b

3583: and p_effective_date between effective_start_date
3584: and effective_end_date;
3585: --
3586: cursor c2 is select null
3587: from ben_pgm_f a, ben_ptip_f b
3588: where b.ptip_id = p_ptip_id
3589: and a.pgm_id = b.pgm_id
3590: and (a.pgm_typ_cd = 'FLEX' or pgm_typ_cd = 'FPC')
3591: and b.business_group_id = p_business_group_id

Line 4516: (p_base_table_name => 'ben_pgm_f',

4512: Raise l_integrity_error;
4513: End If;
4514: If ((nvl(p_pgm_id, hr_api.g_number) <> hr_api.g_number) and
4515: NOT (dt_api.check_min_max_dates
4516: (p_base_table_name => 'ben_pgm_f',
4517: p_base_key_column => 'pgm_id',
4518: p_base_key_value => p_pgm_id,
4519: p_from_date => p_validation_start_date,
4520: p_to_date => p_validation_end_date))) Then

Line 4521: l_table_name := 'ben_pgm_f';

4517: p_base_key_column => 'pgm_id',
4518: p_base_key_value => p_pgm_id,
4519: p_from_date => p_validation_start_date,
4520: p_to_date => p_validation_end_date))) Then
4521: l_table_name := 'ben_pgm_f';
4522: Raise l_integrity_error;
4523: End If;
4524: If ((nvl(p_parnt_acty_base_rt_id, hr_api.g_number) <> hr_api.g_number) and
4525: NOT (dt_api.check_min_max_dates