APPS.BEN_ELIGY_PROFILE_API dependencies on BEN_ELIG_ENRLD_ANTHR_PL_F

Line 1216: cursor BEN_ELIG_ENRLD_ANTHR_PL_F is

1212: and a.effective_end_date = (select max(b.effective_end_date)
1213: from BEN_ELIG_ENRLD_ANTHR_PLIP_F b
1214: where a.elig_enrld_anthr_plip_id = b.elig_enrld_anthr_plip_id);
1215:
1216: cursor BEN_ELIG_ENRLD_ANTHR_PL_F is
1217: select a.elig_enrld_anthr_pl_id, a.object_version_number, a.effective_end_date eed
1218: from BEN_ELIG_ENRLD_ANTHR_PL_F a
1219: where a.eligy_prfl_id = p_eligy_prfl_id
1220: and a.effective_end_date = (select max(b.effective_end_date)

Line 1218: from BEN_ELIG_ENRLD_ANTHR_PL_F a

1214: where a.elig_enrld_anthr_plip_id = b.elig_enrld_anthr_plip_id);
1215:
1216: cursor BEN_ELIG_ENRLD_ANTHR_PL_F is
1217: select a.elig_enrld_anthr_pl_id, a.object_version_number, a.effective_end_date eed
1218: from BEN_ELIG_ENRLD_ANTHR_PL_F a
1219: where a.eligy_prfl_id = p_eligy_prfl_id
1220: and a.effective_end_date = (select max(b.effective_end_date)
1221: from BEN_ELIG_ENRLD_ANTHR_PL_F b
1222: where a.elig_enrld_anthr_pl_id = b.elig_enrld_anthr_pl_id);

Line 1221: from BEN_ELIG_ENRLD_ANTHR_PL_F b

1217: select a.elig_enrld_anthr_pl_id, a.object_version_number, a.effective_end_date eed
1218: from BEN_ELIG_ENRLD_ANTHR_PL_F a
1219: where a.eligy_prfl_id = p_eligy_prfl_id
1220: and a.effective_end_date = (select max(b.effective_end_date)
1221: from BEN_ELIG_ENRLD_ANTHR_PL_F b
1222: where a.elig_enrld_anthr_pl_id = b.elig_enrld_anthr_pl_id);
1223:
1224: cursor BEN_ELIG_ENRLD_ANTHR_PTIP_F is
1225: select a.elig_enrld_anthr_ptip_id, a.object_version_number, a.effective_end_date eed

Line 1857: for l_row in BEN_ELIG_ENRLD_ANTHR_PL_F loop

1853: ,p_effective_date => l_effective_date
1854: ,p_datetrack_mode => p_datetrack_mode);
1855: end if;
1856: end loop;
1857: for l_row in BEN_ELIG_ENRLD_ANTHR_PL_F loop
1858: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1859: or p_datetrack_mode <> hr_api.g_delete then
1860: if p_datetrack_mode = hr_api.g_zap then
1861: l_effective_date := l_row.eed;