APPS.BEN_ELIGY_PROFILE_API dependencies on BEN_ELIG_EE_STAT_PRTE_F

Line 1184: cursor BEN_ELIG_EE_STAT_PRTE_F is

1180: and a.effective_end_date = (select max(b.effective_end_date)
1181: from BEN_ELIG_DPNT_CVRD_PLIP_F b
1182: where a.elig_dpnt_cvrd_plip_id = b.elig_dpnt_cvrd_plip_id);
1183:
1184: cursor BEN_ELIG_EE_STAT_PRTE_F is
1185: select a.elig_ee_stat_prte_id, a.object_version_number, a.effective_end_date eed
1186: from BEN_ELIG_EE_STAT_PRTE_F a
1187: where a.eligy_prfl_id = p_eligy_prfl_id
1188: and a.effective_end_date = (select max(b.effective_end_date)

Line 1186: from BEN_ELIG_EE_STAT_PRTE_F a

1182: where a.elig_dpnt_cvrd_plip_id = b.elig_dpnt_cvrd_plip_id);
1183:
1184: cursor BEN_ELIG_EE_STAT_PRTE_F is
1185: select a.elig_ee_stat_prte_id, a.object_version_number, a.effective_end_date eed
1186: from BEN_ELIG_EE_STAT_PRTE_F a
1187: where a.eligy_prfl_id = p_eligy_prfl_id
1188: and a.effective_end_date = (select max(b.effective_end_date)
1189: from BEN_ELIG_EE_STAT_PRTE_F b
1190: where a.elig_ee_stat_prte_id = b.elig_ee_stat_prte_id);

Line 1189: from BEN_ELIG_EE_STAT_PRTE_F b

1185: select a.elig_ee_stat_prte_id, a.object_version_number, a.effective_end_date eed
1186: from BEN_ELIG_EE_STAT_PRTE_F a
1187: where a.eligy_prfl_id = p_eligy_prfl_id
1188: and a.effective_end_date = (select max(b.effective_end_date)
1189: from BEN_ELIG_EE_STAT_PRTE_F b
1190: where a.elig_ee_stat_prte_id = b.elig_ee_stat_prte_id);
1191:
1192: cursor BEN_ELIG_ENRLD_ANTHR_OIPL_F is
1193: select a.elig_enrld_anthr_oipl_id, a.object_version_number, a.effective_end_date eed

Line 1789: for l_row in BEN_ELIG_EE_STAT_PRTE_F loop

1785: ,p_effective_date => l_effective_date
1786: ,p_datetrack_mode => p_datetrack_mode);
1787: end if;
1788: end loop;
1789: for l_row in BEN_ELIG_EE_STAT_PRTE_F loop
1790: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1791: or p_datetrack_mode <> hr_api.g_delete then
1792: if p_datetrack_mode = hr_api.g_zap then
1793: l_effective_date := l_row.eed;