APPS.BEN_BATCH_DT_API dependencies on BEN_ELIG_PER_F

Line 958: from ben_elig_per_f

954: is
955: select elig_per_id id,
956: min(effective_start_date) min_esd,
957: max(effective_end_date) max_eed
958: from ben_elig_per_f
959: where elig_per_id = c_id
960: group by elig_per_id;
961: --
962: begin

Line 1260: from ben_elig_per_f pep

1256: )
1257: is
1258: select pep.effective_start_date,
1259: pep.effective_end_date
1260: from ben_elig_per_f pep
1261: where pep.elig_per_id = c_pep_id
1262: and c_eff_date
1263: between pep.effective_start_date and pep.effective_end_date;
1264: --

Line 1283: if p_base_table_name = 'BEN_ELIG_PER_F'

1279: --
1280: p_effective_start_date := null;
1281: p_effective_end_date := null;
1282: --
1283: if p_base_table_name = 'BEN_ELIG_PER_F'
1284: then
1285: --
1286: open c_effdates
1287: (c_eff_date => p_effective_date

Line 1348: from ben_elig_per_f pep

1344: (c_id number
1345: )
1346: is
1347: select max(pep.effective_end_date)
1348: from ben_elig_per_f pep
1349: where pep.elig_per_id = c_id;
1350: --
1351: cursor c_epomaxedate
1352: (c_id number

Line 1362: if p_base_table_name = 'BEN_ELIG_PER_F'

1358: --
1359: BEGIN
1360: hr_utility.set_location('Entering:'||l_proc, 5);
1361: --
1362: if p_base_table_name = 'BEN_ELIG_PER_F'
1363: then
1364: --
1365: open c_maxedate
1366: (c_id => p_base_key_value

Line 1458: l_table_name := 'BEN_ELIG_PER_F';

1454: l_table_name varchar2(100);
1455: --
1456: begin
1457: --
1458: l_table_name := 'BEN_ELIG_PER_F';
1459: --
1460: if p_datetrack_mode = hr_api.g_correction
1461: then
1462: --

Line 1523: ,p_base_table_name => 'ben_elig_per_f'

1519: --
1520: dt_api.validate_dt_mode
1521: (p_effective_date => p_effective_date
1522: ,p_datetrack_mode => p_datetrack_mode
1523: ,p_base_table_name => 'ben_elig_per_f'
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'

Line 1646: ,p_parent_table_name1 => 'ben_elig_per_f'

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'
1648: ,p_parent_key_value1 => ben_epo_shd.g_old_rec.elig_per_id
1649: ,p_parent_table_name2 => 'ben_opt_f'
1650: ,p_parent_key_column2 => 'opt_id'