APPS.BEN_ELIGY_PROFILE_API dependencies on BEN_ELIG_TTL_CVG_VOL_PRTE_F

Line 1519: cursor BEN_ELIG_TTL_CVG_VOL_PRTE_F is

1515: from BEN_ELIG_DSBLD_PRTE_F a
1516: where a.eligy_prfl_id = p_eligy_prfl_id
1517: and p_effective_date between a.effective_start_date and a.effective_end_date ;
1518:
1519: cursor BEN_ELIG_TTL_CVG_VOL_PRTE_F is
1520: select a.ELIG_TTL_CVG_VOL_PRTE_ID , a.object_version_number, a.effective_end_date eed
1521: from BEN_ELIG_TTL_CVG_VOL_PRTE_F a
1522: where a.eligy_prfl_id = p_eligy_prfl_id
1523: and p_effective_date between a.effective_start_date and a.effective_end_date ;

Line 1521: from BEN_ELIG_TTL_CVG_VOL_PRTE_F a

1517: and p_effective_date between a.effective_start_date and a.effective_end_date ;
1518:
1519: cursor BEN_ELIG_TTL_CVG_VOL_PRTE_F is
1520: select a.ELIG_TTL_CVG_VOL_PRTE_ID , a.object_version_number, a.effective_end_date eed
1521: from BEN_ELIG_TTL_CVG_VOL_PRTE_F a
1522: where a.eligy_prfl_id = p_eligy_prfl_id
1523: and p_effective_date between a.effective_start_date and a.effective_end_date ;
1524:
1525: cursor BEN_ELIG_TTL_PRTT_PRTE_F is

Line 2521: for l_row in BEN_ELIG_TTL_CVG_VOL_PRTE_F loop

2517: ,p_datetrack_mode => p_datetrack_mode);
2518: end if;
2519: end loop;
2520:
2521: for l_row in BEN_ELIG_TTL_CVG_VOL_PRTE_F loop
2522: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2523: or p_datetrack_mode <> hr_api.g_delete then
2524: if p_datetrack_mode = hr_api.g_zap then
2525: l_effective_date := l_row.eed;