APPS.BEN_ELIGY_PROFILE_API dependencies on BEN_ELIG_GNDR_PRTE_F

Line 1451: cursor BEN_ELIG_GNDR_PRTE_F is

1447: where a.cntng_prtn_elig_prfl_id = b.cntng_prtn_elig_prfl_id);
1448:
1449:
1450:
1451: cursor BEN_ELIG_GNDR_PRTE_F is
1452: select a.ELIG_GNDR_PRTE_ID, a.object_version_number, a.effective_end_date eed
1453: from BEN_ELIG_GNDR_PRTE_F a
1454: where a.eligy_prfl_id = p_eligy_prfl_id
1455: and p_effective_date between a.effective_start_date and a.effective_end_date ;

Line 1453: from BEN_ELIG_GNDR_PRTE_F a

1449:
1450:
1451: cursor BEN_ELIG_GNDR_PRTE_F is
1452: select a.ELIG_GNDR_PRTE_ID, a.object_version_number, a.effective_end_date eed
1453: from BEN_ELIG_GNDR_PRTE_F a
1454: where a.eligy_prfl_id = p_eligy_prfl_id
1455: and p_effective_date between a.effective_start_date and a.effective_end_date ;
1456:
1457:

Line 2353: for l_row in BEN_ELIG_GNDR_PRTE_F loop

2349: end if;
2350: end loop;
2351:
2352:
2353: for l_row in BEN_ELIG_GNDR_PRTE_F loop
2354: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
2355: or p_datetrack_mode <> hr_api.g_delete then
2356: if p_datetrack_mode = hr_api.g_zap then
2357: l_effective_date := l_row.eed;