APPS.BEN_ELIGY_PROFILE_API dependencies on BEN_ELIG_QUAL_TITL_PRTE_F

Line 1488: cursor BEN_ELIG_qual_titl_prte_f is

1484: from BEN_ELIG_Suppl_role_prte_f a
1485: where a.eligy_prfl_id = p_eligy_prfl_id
1486: and p_effective_date between a.effective_start_date and a.effective_end_date ;
1487:
1488: cursor BEN_ELIG_qual_titl_prte_f is
1489: select a.ELIG_qual_titl_prte_ID , a.object_version_number, a.effective_end_date eed
1490: from BEN_ELIG_qual_titl_prte_f a
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 ;

Line 1490: from BEN_ELIG_qual_titl_prte_f a

1486: and p_effective_date between a.effective_start_date and a.effective_end_date ;
1487:
1488: cursor BEN_ELIG_qual_titl_prte_f is
1489: select a.ELIG_qual_titl_prte_ID , a.object_version_number, a.effective_end_date eed
1490: from BEN_ELIG_qual_titl_prte_f a
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:

Line 2442: for l_row in BEN_ELIG_qual_titl_prte_f loop

2438: ,p_datetrack_mode => p_datetrack_mode);
2439: end loop;
2440:
2441:
2442: for l_row in BEN_ELIG_qual_titl_prte_f loop
2443: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2444: or p_datetrack_mode <> hr_api.g_delete then
2445: if p_datetrack_mode = hr_api.g_zap then
2446: l_effective_date := l_row.eed;