APPS.BEN_ELIGY_PROFILE_API dependencies on BEN_ELIG_GRD_PRTE_F

Line 1240: cursor BEN_ELIG_GRD_PRTE_F is

1236: and a.effective_end_date = (select max(b.effective_end_date)
1237: from BEN_ELIG_FL_TM_PT_TM_PRTE_F b
1238: where a.elig_fl_tm_pt_tm_prte_id = b.elig_fl_tm_pt_tm_prte_id);
1239:
1240: cursor BEN_ELIG_GRD_PRTE_F is
1241: select a.elig_grd_prte_id, a.object_version_number, a.effective_end_date eed
1242: from BEN_ELIG_GRD_PRTE_F a
1243: where a.eligy_prfl_id = p_eligy_prfl_id
1244: and a.effective_end_date = (select max(b.effective_end_date)

Line 1242: from BEN_ELIG_GRD_PRTE_F a

1238: where a.elig_fl_tm_pt_tm_prte_id = b.elig_fl_tm_pt_tm_prte_id);
1239:
1240: cursor BEN_ELIG_GRD_PRTE_F is
1241: select a.elig_grd_prte_id, a.object_version_number, a.effective_end_date eed
1242: from BEN_ELIG_GRD_PRTE_F a
1243: where a.eligy_prfl_id = p_eligy_prfl_id
1244: and a.effective_end_date = (select max(b.effective_end_date)
1245: from BEN_ELIG_GRD_PRTE_F b
1246: where a.elig_grd_prte_id = b.elig_grd_prte_id);

Line 1245: from BEN_ELIG_GRD_PRTE_F b

1241: select a.elig_grd_prte_id, a.object_version_number, a.effective_end_date eed
1242: from BEN_ELIG_GRD_PRTE_F a
1243: where a.eligy_prfl_id = p_eligy_prfl_id
1244: and a.effective_end_date = (select max(b.effective_end_date)
1245: from BEN_ELIG_GRD_PRTE_F b
1246: where a.elig_grd_prte_id = b.elig_grd_prte_id);
1247:
1248: cursor BEN_ELIG_HRLY_SLRD_PRTE_F is
1249: select a.elig_hrly_slrd_prte_id, a.object_version_number, a.effective_end_date eed

Line 1908: for l_row in BEN_ELIG_GRD_PRTE_F loop

1904: ,p_effective_date => l_effective_date
1905: ,p_datetrack_mode => p_datetrack_mode);
1906: end if;
1907: end loop;
1908: for l_row in BEN_ELIG_GRD_PRTE_F loop
1909: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1910: or p_datetrack_mode <> hr_api.g_delete then
1911: if p_datetrack_mode = hr_api.g_zap then
1912: l_effective_date := l_row.eed;