DBA Data[Home] [Help]

APPS.BEN_ELIGY_PROFILE_API dependencies on BEN_ELIGY_CRIT_VALUES_F

Line 1563: cursor BEN_ELIGY_CRIT_VALUES_F is

1559: and p_effective_date between a.effective_start_date and a.effective_end_date ;
1560: --
1561: -- Bug No 4411798
1562: --
1563: cursor BEN_ELIGY_CRIT_VALUES_F is
1564: select a.ELIGY_CRIT_VALUES_ID , a.object_version_number, a.effective_end_date eed
1565: from BEN_ELIGY_CRIT_VALUES_F a
1566: where a.eligy_prfl_id = p_eligy_prfl_id
1567: and p_effective_date between a.effective_start_date and a.effective_end_date ;

Line 1565: from BEN_ELIGY_CRIT_VALUES_F a

1561: -- Bug No 4411798
1562: --
1563: cursor BEN_ELIGY_CRIT_VALUES_F is
1564: select a.ELIGY_CRIT_VALUES_ID , a.object_version_number, a.effective_end_date eed
1565: from BEN_ELIGY_CRIT_VALUES_F a
1566: where a.eligy_prfl_id = p_eligy_prfl_id
1567: and p_effective_date between a.effective_start_date and a.effective_end_date ;
1568: --
1569: -- End Bug No 4411798

Line 2657: for l_row in BEN_ELIGY_CRIT_VALUES_F loop

2653:
2654: --
2655: -- Bug No 4411798
2656: --
2657: for l_row in BEN_ELIGY_CRIT_VALUES_F loop
2658: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2659: or p_datetrack_mode <> hr_api.g_delete then
2660: if p_datetrack_mode = hr_api.g_zap then
2661: l_effective_date := l_row.eed;