APPS.BEN_ELIGY_PROFILE_API dependencies on BEN_PRTN_ELIG_PRFL_F

Line 1432: cursor BEN_PRTN_ELIG_PRFL_F is

1428: and a.effective_end_date = (select max(b.effective_end_date)
1429: from BEN_ELIG_WK_LOC_PRTE_F b
1430: where a.elig_wk_loc_prte_id = b.elig_wk_loc_prte_id);
1431:
1432: cursor BEN_PRTN_ELIG_PRFL_F is
1433: select a.prtn_elig_prfl_id, a.object_version_number, a.effective_end_date eed
1434: from BEN_PRTN_ELIG_PRFL_F a
1435: where a.eligy_prfl_id = p_eligy_prfl_id
1436: and a.effective_end_date = (select max(b.effective_end_date)

Line 1434: from BEN_PRTN_ELIG_PRFL_F a

1430: where a.elig_wk_loc_prte_id = b.elig_wk_loc_prte_id);
1431:
1432: cursor BEN_PRTN_ELIG_PRFL_F is
1433: select a.prtn_elig_prfl_id, a.object_version_number, a.effective_end_date eed
1434: from BEN_PRTN_ELIG_PRFL_F a
1435: where a.eligy_prfl_id = p_eligy_prfl_id
1436: and a.effective_end_date = (select max(b.effective_end_date)
1437: from BEN_PRTN_ELIG_PRFL_F b
1438: where a.prtn_elig_prfl_id = b.prtn_elig_prfl_id);

Line 1437: from BEN_PRTN_ELIG_PRFL_F b

1433: select a.prtn_elig_prfl_id, a.object_version_number, a.effective_end_date eed
1434: from BEN_PRTN_ELIG_PRFL_F a
1435: where a.eligy_prfl_id = p_eligy_prfl_id
1436: and a.effective_end_date = (select max(b.effective_end_date)
1437: from BEN_PRTN_ELIG_PRFL_F b
1438: where a.prtn_elig_prfl_id = b.prtn_elig_prfl_id);
1439:
1440:
1441: cursor BEN_CNTNG_PRTN_ELIG_PRFL_F is

Line 2316: for l_row in BEN_PRTN_ELIG_PRFL_F loop

2312: ,p_effective_date => l_effective_date
2313: ,p_datetrack_mode => p_datetrack_mode);
2314: end if;
2315: end loop;
2316: for l_row in BEN_PRTN_ELIG_PRFL_F loop
2317: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2318: or p_datetrack_mode <> hr_api.g_delete then
2319: if p_datetrack_mode = hr_api.g_zap then
2320: l_effective_date := l_row.eed;