APPS.BEN_ELIGY_PROFILE_API dependencies on BEN_ELIG_LGL_ENTY_PRTE_F

Line 1280: cursor BEN_ELIG_LGL_ENTY_PRTE_F is

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
1282: from BEN_ELIG_LGL_ENTY_PRTE_F a
1283: where a.eligy_prfl_id = p_eligy_prfl_id
1284: and a.effective_end_date = (select max(b.effective_end_date)

Line 1282: from BEN_ELIG_LGL_ENTY_PRTE_F a

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
1282: from BEN_ELIG_LGL_ENTY_PRTE_F a
1283: where a.eligy_prfl_id = p_eligy_prfl_id
1284: and a.effective_end_date = (select max(b.effective_end_date)
1285: from BEN_ELIG_LGL_ENTY_PRTE_F b
1286: where a.elig_lgl_enty_prte_id = b.elig_lgl_enty_prte_id);

Line 1285: from BEN_ELIG_LGL_ENTY_PRTE_F b

1281: select a.elig_lgl_enty_prte_id, a.object_version_number, a.effective_end_date eed
1282: from BEN_ELIG_LGL_ENTY_PRTE_F a
1283: where a.eligy_prfl_id = p_eligy_prfl_id
1284: and a.effective_end_date = (select max(b.effective_end_date)
1285: from BEN_ELIG_LGL_ENTY_PRTE_F b
1286: where a.elig_lgl_enty_prte_id = b.elig_lgl_enty_prte_id);
1287:
1288: cursor BEN_ELIG_LOA_RSN_PRTE_F is
1289: select a.elig_loa_rsn_prte_id, a.object_version_number, a.effective_end_date eed

Line 1993: for l_row in BEN_ELIG_LGL_ENTY_PRTE_F loop

1989: ,p_effective_date => l_effective_date
1990: ,p_datetrack_mode => p_datetrack_mode);
1991: end if;
1992: end loop;
1993: for l_row in BEN_ELIG_LGL_ENTY_PRTE_F loop
1994: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1995: or p_datetrack_mode <> hr_api.g_delete then
1996: if p_datetrack_mode = hr_api.g_zap then
1997: l_effective_date := l_row.eed;