APPS.BEN_PGM_BUS dependencies on BEN_POPL_YR_PERD

Line 5988: from ben_popl_yr_perd t

5984: l_val number;
5985: --
5986: Cursor c_yr_perd_exists(p_pgm_id in number ) Is
5987: select 1
5988: from ben_popl_yr_perd t
5989: where t.pl_id = p_pgm_id ;
5990: --
5991: Begin
5992: hr_utility.set_location('Entering:'||l_proc, 5);

Line 6174: (p_base_table_name => 'ben_popl_yr_perd',

6170: End If;
6171: hr_utility.set_location('!!!!! 19', 5);
6172:
6173: If (dt_api.rows_exist -- Uncommented, Bug 4339842
6174: (p_base_table_name => 'ben_popl_yr_perd',
6175: p_base_key_column => 'pgm_id',
6176: p_base_key_value => p_pgm_id,
6177: p_from_date => p_validation_start_date,
6178: p_to_date => p_validation_end_date)) Then

Line 6179: l_table_name := 'ben_popl_yr_perd';

6175: p_base_key_column => 'pgm_id',
6176: p_base_key_value => p_pgm_id,
6177: p_from_date => p_validation_start_date,
6178: p_to_date => p_validation_end_date)) Then
6179: l_table_name := 'ben_popl_yr_perd';
6180: Raise l_rows_exist;
6181: End If;
6182: */
6183: open c_yr_perd_exists(p_pgm_id );

Line 6188: l_table_name := 'ben_popl_yr_perd';

6184: fetch c_yr_perd_exists into l_val ;
6185: if c_yr_perd_exists%found
6186: then
6187: close c_yr_perd_exists;
6188: l_table_name := 'ben_popl_yr_perd';
6189: Raise l_rows_exist;
6190: end if;
6191: close c_yr_perd_exists;
6192: --