APPS.BEN_ELIGY_PROFILE_API dependencies on BEN_ELIG_PSTN_PRTE_F

Line 1495: cursor BEN_ELIG_pstn_prte_f is

1491: where a.eligy_prfl_id = p_eligy_prfl_id
1492: and p_effective_date between a.effective_start_date and a.effective_end_date ;
1493:
1494:
1495: cursor BEN_ELIG_pstn_prte_f is
1496: select a.ELIG_pstn_prte_ID , a.object_version_number, a.effective_end_date eed
1497: from BEN_ELIG_pstn_prte_f a
1498: where a.eligy_prfl_id = p_eligy_prfl_id
1499: and p_effective_date between a.effective_start_date and a.effective_end_date ;

Line 1497: from BEN_ELIG_pstn_prte_f a

1493:
1494:
1495: cursor BEN_ELIG_pstn_prte_f is
1496: select a.ELIG_pstn_prte_ID , a.object_version_number, a.effective_end_date eed
1497: from BEN_ELIG_pstn_prte_f a
1498: where a.eligy_prfl_id = p_eligy_prfl_id
1499: and p_effective_date between a.effective_start_date and a.effective_end_date ;
1500:
1501: cursor BEN_ELIG_prbtn_perd_prte_f is

Line 2461: for l_row in BEN_ELIG_pstn_prte_f loop

2457: ,p_datetrack_mode => p_datetrack_mode);
2458: end if;
2459: end loop;
2460:
2461: for l_row in BEN_ELIG_pstn_prte_f loop
2462: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2463: or p_datetrack_mode <> hr_api.g_delete then
2464: if p_datetrack_mode = hr_api.g_zap then
2465: l_effective_date := l_row.eed;