DBA Data[Home] [Help]

APPS.BEN_BATCH_DT_API dependencies on BEN_PEP_SHD

Line 1528: ,p_parent_key_value1 => ben_pep_shd.g_old_rec.ler_id

1524: ,p_base_key_column => 'elig_per_id'
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'

Line 1531: ,p_parent_key_value2 => ben_pep_shd.g_old_rec.pgm_id

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

Line 1534: ,p_parent_key_value3 => ben_pep_shd.g_old_rec.pl_id

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

Line 1537: ,p_parent_key_value4 => ben_pep_shd.g_old_rec.person_id

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'
1540: ,p_parent_key_value5 => ben_pep_shd.g_old_rec.plip_id
1541: ,p_parent_table_name6 => 'ben_ptip_f'

Line 1540: ,p_parent_key_value5 => ben_pep_shd.g_old_rec.plip_id

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'
1540: ,p_parent_key_value5 => ben_pep_shd.g_old_rec.plip_id
1541: ,p_parent_table_name6 => 'ben_ptip_f'
1542: ,p_parent_key_column6 => 'ptip_id'
1543: ,p_parent_key_value6 => ben_pep_shd.g_old_rec.ptip_id
1544: ,p_child_table_name1 => 'ben_elig_per_opt_f'

Line 1543: ,p_parent_key_value6 => ben_pep_shd.g_old_rec.ptip_id

1539: ,p_parent_key_column5 => 'plip_id'
1540: ,p_parent_key_value5 => ben_pep_shd.g_old_rec.plip_id
1541: ,p_parent_table_name6 => 'ben_ptip_f'
1542: ,p_parent_key_column6 => 'ptip_id'
1543: ,p_parent_key_value6 => ben_pep_shd.g_old_rec.ptip_id
1544: ,p_child_table_name1 => 'ben_elig_per_opt_f'
1545: ,p_child_key_column1 => 'elig_per_opt_id'
1546: ,p_enforce_foreign_locking => false
1547: ,p_validation_start_date => l_validation_start_date