DBA Data[Home] [Help]

APPS.BEN_BATCH_DT_API dependencies on BEN_PL_F

Line 821: from ben_pl_f

817: is
818: select pl_id id,
819: min(effective_start_date) min_esd,
820: max(effective_end_date) max_eed
821: from ben_pl_f
822: where pl_id = c_id
823: group by pl_id;
824: --
825: begin

Line 1532: ,p_parent_table_name3 => 'ben_pl_f'

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'
1534: ,p_parent_key_value3 => ben_pep_shd.g_old_rec.pl_id
1535: ,p_parent_table_name4 => 'per_all_people_f'
1536: ,p_parent_key_column4 => 'person_id'