DBA Data[Home] [Help]

APPS.BEN_BATCH_DT_API dependencies on PER_ALL_PEOPLE_F

Line 136: from per_all_people_f

132: is
133: select person_id id,
134: min(effective_start_date) min_esd,
135: max(effective_end_date) max_eed
136: from per_all_people_f
137: where person_id = c_id
138: group by person_id;
139: --
140: begin

Line 1535: ,p_parent_table_name4 => 'per_all_people_f'

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'
1537: ,p_parent_key_value4 => ben_pep_shd.g_old_rec.person_id
1538: ,p_parent_table_name5 => 'ben_plip_f'
1539: ,p_parent_key_column5 => 'plip_id'