APPS.BEN_ABR_BUS dependencies on BEN_PTIP_F

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 4536: (p_base_table_name => 'ben_ptip_f',

4532: Raise l_integrity_error;
4533: End If;
4534: If ((nvl(p_ptip_id, hr_api.g_number) <> hr_api.g_number) and
4535: NOT (dt_api.check_min_max_dates
4536: (p_base_table_name => 'ben_ptip_f',
4537: p_base_key_column => 'ptip_id',
4538: p_base_key_value => p_ptip_id,
4539: p_from_date => p_validation_start_date,
4540: p_to_date => p_validation_end_date))) Then

Line 4541: l_table_name := 'ben_ptip_f';

4537: p_base_key_column => 'ptip_id',
4538: p_base_key_value => p_ptip_id,
4539: p_from_date => p_validation_start_date,
4540: p_to_date => p_validation_end_date))) Then
4541: l_table_name := 'ben_ptip_f';
4542: Raise l_integrity_error;
4543: End If;
4544: If ((nvl(p_oipl_id, hr_api.g_number) <> hr_api.g_number) and
4545: NOT (dt_api.check_min_max_dates