APPS.BEN_PEN_BUS dependencies on BEN_PGM_F

Line 1659: l_prev_pgm_id ben_pgm_f.pgm_id%type := -99999;

1655: index by binary_integer;
1656: --
1657: -- Local Variable declaration
1658: --
1659: l_prev_pgm_id ben_pgm_f.pgm_id%type := -99999;
1660: l_prev_ptip_id ben_ptip_f.ptip_id%type := -99999;
1661: l_prev_pl_typ_id ben_pl_typ_f.pl_typ_id%type := -99999;
1662: l_prev_pl_id ben_pl_f.pl_id%type := -99999;
1663: l_pl_typ_rec g_c_pl_typ%rowtype;

Line 3723: (p_base_table_name => 'ben_pgm_f',

3719: p_argument_value => p_validation_end_date);
3720: --
3721: If ((nvl(p_pgm_id, hr_api.g_number) <> hr_api.g_number) and
3722: NOT (dt_api.check_min_max_dates
3723: (p_base_table_name => 'ben_pgm_f',
3724: p_base_key_column => 'pgm_id',
3725: p_base_key_value => p_pgm_id,
3726: p_from_date => p_validation_start_date,
3727: p_to_date => p_validation_end_date))) Then

Line 3728: l_table_name := 'ben_pgm_f';

3724: p_base_key_column => 'pgm_id',
3725: p_base_key_value => p_pgm_id,
3726: p_from_date => p_validation_start_date,
3727: p_to_date => p_validation_end_date))) Then
3728: l_table_name := 'ben_pgm_f';
3729: Raise l_integrity_error;
3730: End If;
3731: If ((nvl(p_oipl_id, hr_api.g_number) <> hr_api.g_number) and
3732: NOT (dt_api.check_min_max_dates