APPS.BEN_ELIGY_PROFILE_API dependencies on BEN_ELIG_PRTT_ANTHR_PL_PRTE_F

Line 1376: cursor BEN_ELIG_PRTT_ANTHR_PL_PRTE_F is

1372: and a.effective_end_date = (select max(b.effective_end_date)
1373: from BEN_ELIG_PPL_GRP_PRTE_F b
1374: where a.elig_ppl_grp_prte_id = b.elig_ppl_grp_prte_id);
1375:
1376: cursor BEN_ELIG_PRTT_ANTHR_PL_PRTE_F is
1377: select a.elig_prtt_anthr_pl_prte_id, a.object_version_number, a.effective_end_date eed
1378: from BEN_ELIG_PRTT_ANTHR_PL_PRTE_F a
1379: where a.eligy_prfl_id = p_eligy_prfl_id
1380: and a.effective_end_date = (select max(b.effective_end_date)

Line 1378: from BEN_ELIG_PRTT_ANTHR_PL_PRTE_F a

1374: where a.elig_ppl_grp_prte_id = b.elig_ppl_grp_prte_id);
1375:
1376: cursor BEN_ELIG_PRTT_ANTHR_PL_PRTE_F is
1377: select a.elig_prtt_anthr_pl_prte_id, a.object_version_number, a.effective_end_date eed
1378: from BEN_ELIG_PRTT_ANTHR_PL_PRTE_F a
1379: where a.eligy_prfl_id = p_eligy_prfl_id
1380: and a.effective_end_date = (select max(b.effective_end_date)
1381: from BEN_ELIG_PRTT_ANTHR_PL_PRTE_F b
1382: where a.elig_prtt_anthr_pl_prte_id = b.elig_prtt_anthr_pl_prte_id);

Line 1381: from BEN_ELIG_PRTT_ANTHR_PL_PRTE_F b

1377: select a.elig_prtt_anthr_pl_prte_id, a.object_version_number, a.effective_end_date eed
1378: from BEN_ELIG_PRTT_ANTHR_PL_PRTE_F a
1379: where a.eligy_prfl_id = p_eligy_prfl_id
1380: and a.effective_end_date = (select max(b.effective_end_date)
1381: from BEN_ELIG_PRTT_ANTHR_PL_PRTE_F b
1382: where a.elig_prtt_anthr_pl_prte_id = b.elig_prtt_anthr_pl_prte_id);
1383:
1384: cursor BEN_ELIG_PSTL_CD_R_RNG_PRTE_F is
1385: select a.elig_pstl_cd_r_rng_prte_id, a.object_version_number, a.effective_end_date eed

Line 2197: for l_row in BEN_ELIG_PRTT_ANTHR_PL_PRTE_F loop

2193: ,p_effective_date => l_effective_date
2194: ,p_datetrack_mode => p_datetrack_mode);
2195: end if;
2196: end loop;
2197: for l_row in BEN_ELIG_PRTT_ANTHR_PL_PRTE_F loop
2198: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2199: or p_datetrack_mode <> hr_api.g_delete then
2200: if p_datetrack_mode = hr_api.g_zap then
2201: l_effective_date := l_row.eed;