DBA Data[Home] [Help]

APPS.BEN_ELIGY_PROFILE_API dependencies on BEN_ELIG_QUA_IN_GR_PRTE_F

Line 1549: cursor BEN_ELIG_QUA_IN_GR_PRTE_F is

1545: from BEN_ELIG_COMPTNCY_PRTE_F a
1546: where a.eligy_prfl_id = p_eligy_prfl_id
1547: and p_effective_date between a.effective_start_date and a.effective_end_date ;
1548:
1549: cursor BEN_ELIG_QUA_IN_GR_PRTE_F is
1550: select a.ELIG_QUA_IN_GR_PRTE_ID , a.object_version_number, a.effective_end_date eed
1551: from BEN_ELIG_QUA_IN_GR_PRTE_F a
1552: where a.eligy_prfl_id = p_eligy_prfl_id
1553: and p_effective_date between a.effective_start_date and a.effective_end_date ;

Line 1551: from BEN_ELIG_QUA_IN_GR_PRTE_F a

1547: and p_effective_date between a.effective_start_date and a.effective_end_date ;
1548:
1549: cursor BEN_ELIG_QUA_IN_GR_PRTE_F is
1550: select a.ELIG_QUA_IN_GR_PRTE_ID , a.object_version_number, a.effective_end_date eed
1551: from BEN_ELIG_QUA_IN_GR_PRTE_F a
1552: where a.eligy_prfl_id = p_eligy_prfl_id
1553: and p_effective_date between a.effective_start_date and a.effective_end_date ;
1554:
1555: cursor BEN_ELIG_PERF_RTNG_PRTE_F is

Line 2616: for l_row in BEN_ELIG_QUA_IN_GR_PRTE_F loop

2612: ,p_datetrack_mode => p_datetrack_mode);
2613: end if;
2614: end loop;
2615:
2616: for l_row in BEN_ELIG_QUA_IN_GR_PRTE_F loop
2617: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2618: or p_datetrack_mode <> hr_api.g_delete then
2619: if p_datetrack_mode = hr_api.g_zap then
2620: l_effective_date := l_row.eed;