DBA Data[Home] [Help]

APPS.BEN_BATCH_DT_API dependencies on BEN_PGM_F

Line 410: from ben_pgm_f

406: is
407: select pgm_id id,
408: min(effective_start_date) min_esd,
409: max(effective_end_date) max_eed
410: from ben_pgm_f
411: where pgm_id = c_id
412: group by pgm_id;
413: --
414: begin

Line 1529: ,p_parent_table_name2 => 'ben_pgm_f'

1525: ,p_base_key_value => p_elig_per_id
1526: ,p_parent_table_name1 => 'ben_ler_f'
1527: ,p_parent_key_column1 => 'ler_id'
1528: ,p_parent_key_value1 => ben_pep_shd.g_old_rec.ler_id
1529: ,p_parent_table_name2 => 'ben_pgm_f'
1530: ,p_parent_key_column2 => 'pgm_id'
1531: ,p_parent_key_value2 => ben_pep_shd.g_old_rec.pgm_id
1532: ,p_parent_table_name3 => 'ben_pl_f'
1533: ,p_parent_key_column3 => 'pl_id'