APPS.BEN_ELIGY_PROFILE_API dependencies on BEN_ELIG_LBR_MMBR_PRTE_F

Line 1272: cursor BEN_ELIG_LBR_MMBR_PRTE_F is

1268: and a.effective_end_date = (select max(b.effective_end_date)
1269: from BEN_ELIG_JOB_PRTE_F b
1270: where a.elig_job_prte_id = b.elig_job_prte_id);
1271:
1272: cursor BEN_ELIG_LBR_MMBR_PRTE_F is
1273: select a.elig_lbr_mmbr_prte_id, a.object_version_number, a.effective_end_date eed
1274: from BEN_ELIG_LBR_MMBR_PRTE_F a
1275: where a.eligy_prfl_id = p_eligy_prfl_id
1276: and a.effective_end_date = (select max(b.effective_end_date)

Line 1274: from BEN_ELIG_LBR_MMBR_PRTE_F a

1270: where a.elig_job_prte_id = b.elig_job_prte_id);
1271:
1272: cursor BEN_ELIG_LBR_MMBR_PRTE_F is
1273: select a.elig_lbr_mmbr_prte_id, a.object_version_number, a.effective_end_date eed
1274: from BEN_ELIG_LBR_MMBR_PRTE_F a
1275: where a.eligy_prfl_id = p_eligy_prfl_id
1276: and a.effective_end_date = (select max(b.effective_end_date)
1277: from BEN_ELIG_LBR_MMBR_PRTE_F b
1278: where a.elig_lbr_mmbr_prte_id = b.elig_lbr_mmbr_prte_id);

Line 1277: from BEN_ELIG_LBR_MMBR_PRTE_F b

1273: select a.elig_lbr_mmbr_prte_id, a.object_version_number, a.effective_end_date eed
1274: from BEN_ELIG_LBR_MMBR_PRTE_F a
1275: where a.eligy_prfl_id = p_eligy_prfl_id
1276: and a.effective_end_date = (select max(b.effective_end_date)
1277: from BEN_ELIG_LBR_MMBR_PRTE_F b
1278: where a.elig_lbr_mmbr_prte_id = b.elig_lbr_mmbr_prte_id);
1279:
1280: cursor BEN_ELIG_LGL_ENTY_PRTE_F is
1281: select a.elig_lgl_enty_prte_id, a.object_version_number, a.effective_end_date eed

Line 1976: for l_row in BEN_ELIG_LBR_MMBR_PRTE_F loop

1972: ,p_effective_date => l_effective_date
1973: ,p_datetrack_mode => p_datetrack_mode);
1974: end if;
1975: end loop;
1976: for l_row in BEN_ELIG_LBR_MMBR_PRTE_F loop
1977: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1978: or p_datetrack_mode <> hr_api.g_delete then
1979: if p_datetrack_mode = hr_api.g_zap then
1980: l_effective_date := l_row.eed;