APPS.BEN_BATCH_DT_API dependencies on BEN_ELIG_PER_OPT_F

Line 1272: from ben_elig_per_opt_f epo

1268: )
1269: is
1270: select epo.effective_start_date,
1271: epo.effective_end_date
1272: from ben_elig_per_opt_f epo
1273: where epo.elig_per_opt_id = c_epo_id
1274: and c_eff_date
1275: between epo.effective_start_date and epo.effective_end_date;
1276: --

Line 1293: elsif p_base_table_name = 'BEN_ELIG_PER_OPT_F'

1289: );
1290: fetch c_effdates into p_effective_start_date, p_effective_end_date;
1291: close c_effdates;
1292: --
1293: elsif p_base_table_name = 'BEN_ELIG_PER_OPT_F'
1294: then
1295: --
1296: open c_epoeffdates
1297: (c_eff_date => p_effective_date

Line 1356: from ben_elig_per_opt_f epo

1352: (c_id number
1353: )
1354: is
1355: select max(epo.effective_end_date)
1356: from ben_elig_per_opt_f epo
1357: where epo.elig_per_opt_id = c_id;
1358: --
1359: BEGIN
1360: hr_utility.set_location('Entering:'||l_proc, 5);

Line 1371: elsif p_base_table_name = 'BEN_ELIG_PER_OPT_F'

1367: );
1368: fetch c_maxedate into l_max_date;
1369: close c_maxedate;
1370: --
1371: elsif p_base_table_name = 'BEN_ELIG_PER_OPT_F'
1372: then
1373: --
1374: open c_epomaxedate
1375: (c_id => p_base_key_value

Line 1544: ,p_child_table_name1 => 'ben_elig_per_opt_f'

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
1548: ,p_validation_end_date => l_validation_end_date

Line 1578: l_table_name := 'BEN_ELIG_PER_OPT_F';

1574: l_table_name varchar2(100);
1575: --
1576: begin
1577: --
1578: l_table_name := 'BEN_ELIG_PER_OPT_F';
1579: --
1580: if p_datetrack_mode = hr_api.g_correction
1581: then
1582: --

Line 1643: ,p_base_table_name => 'ben_elig_per_opt_f'

1639: --
1640: dt_api.validate_dt_mode
1641: (p_effective_date => p_effective_date
1642: ,p_datetrack_mode => p_datetrack_mode
1643: ,p_base_table_name => 'ben_elig_per_opt_f'
1644: ,p_base_key_column => 'elig_per_opt_id'
1645: ,p_base_key_value => p_elig_per_opt_id
1646: ,p_parent_table_name1 => 'ben_elig_per_f'
1647: ,p_parent_key_column1 => 'elig_per_id'