APPS.BEN_PEN_BUS dependencies on BEN_PGM_F

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

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

Line 3722: (p_base_table_name => 'ben_pgm_f',

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

Line 3727: l_table_name := 'ben_pgm_f';

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