APPS.BEN_ELIGY_PROFILE_API dependencies on BEN_ELIG_LVG_RSN_PRTE_F

Line 1304: cursor BEN_ELIG_LVG_RSN_PRTE_F is

1300: and a.effective_end_date = (select max(b.effective_end_date)
1301: from BEN_ELIG_LOS_PRTE_F b
1302: where a.elig_los_prte_id = b.elig_los_prte_id);
1303:
1304: cursor BEN_ELIG_LVG_RSN_PRTE_F is
1305: select a.elig_lvg_rsn_prte_id, a.object_version_number, a.effective_end_date eed
1306: from BEN_ELIG_LVG_RSN_PRTE_F a
1307: where a.eligy_prfl_id = p_eligy_prfl_id
1308: and a.effective_end_date = (select max(b.effective_end_date)

Line 1306: from BEN_ELIG_LVG_RSN_PRTE_F a

1302: where a.elig_los_prte_id = b.elig_los_prte_id);
1303:
1304: cursor BEN_ELIG_LVG_RSN_PRTE_F is
1305: select a.elig_lvg_rsn_prte_id, a.object_version_number, a.effective_end_date eed
1306: from BEN_ELIG_LVG_RSN_PRTE_F a
1307: where a.eligy_prfl_id = p_eligy_prfl_id
1308: and a.effective_end_date = (select max(b.effective_end_date)
1309: from BEN_ELIG_LVG_RSN_PRTE_F b
1310: where a.elig_lvg_rsn_prte_id = b.elig_lvg_rsn_prte_id);

Line 1309: from BEN_ELIG_LVG_RSN_PRTE_F b

1305: select a.elig_lvg_rsn_prte_id, a.object_version_number, a.effective_end_date eed
1306: from BEN_ELIG_LVG_RSN_PRTE_F a
1307: where a.eligy_prfl_id = p_eligy_prfl_id
1308: and a.effective_end_date = (select max(b.effective_end_date)
1309: from BEN_ELIG_LVG_RSN_PRTE_F b
1310: where a.elig_lvg_rsn_prte_id = b.elig_lvg_rsn_prte_id);
1311:
1312: cursor BEN_ELIG_NO_OTHR_CVG_PRTE_F is
1313: select a.elig_no_othr_cvg_prte_id, a.object_version_number, a.effective_end_date eed

Line 2044: for l_row in BEN_ELIG_LVG_RSN_PRTE_F loop

2040: ,p_effective_date => l_effective_date
2041: ,p_datetrack_mode => p_datetrack_mode);
2042: end if;
2043: end loop;
2044: for l_row in BEN_ELIG_LVG_RSN_PRTE_F loop
2045: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2046: or p_datetrack_mode <> hr_api.g_delete then
2047: if p_datetrack_mode = hr_api.g_zap then
2048: l_effective_date := l_row.eed;