APPS.BEN_ELIGY_PROFILE_API dependencies on BEN_ELIG_DPNT_CVRD_OTHR_PTIP_F

Line 1168: cursor BEN_ELIG_DPNT_CVRD_OTHR_PTIP_F is

1164: and a.effective_end_date = (select max(b.effective_end_date)
1165: from BEN_ELIG_DPNT_CVRD_OTHR_PL_F b
1166: where a.elig_dpnt_cvrd_othr_pl_id = b.elig_dpnt_cvrd_othr_pl_id);
1167:
1168: cursor BEN_ELIG_DPNT_CVRD_OTHR_PTIP_F is
1169: select a.elig_dpnt_cvrd_othr_ptip_id, a.object_version_number, a.effective_end_date eed
1170: from BEN_ELIG_DPNT_CVRD_OTHR_PTIP_F a
1171: where a.eligy_prfl_id = p_eligy_prfl_id
1172: and a.effective_end_date = (select max(b.effective_end_date)

Line 1170: from BEN_ELIG_DPNT_CVRD_OTHR_PTIP_F a

1166: where a.elig_dpnt_cvrd_othr_pl_id = b.elig_dpnt_cvrd_othr_pl_id);
1167:
1168: cursor BEN_ELIG_DPNT_CVRD_OTHR_PTIP_F is
1169: select a.elig_dpnt_cvrd_othr_ptip_id, a.object_version_number, a.effective_end_date eed
1170: from BEN_ELIG_DPNT_CVRD_OTHR_PTIP_F a
1171: where a.eligy_prfl_id = p_eligy_prfl_id
1172: and a.effective_end_date = (select max(b.effective_end_date)
1173: from BEN_ELIG_DPNT_CVRD_OTHR_PTIP_F b
1174: where a.elig_dpnt_cvrd_othr_ptip_id = b.elig_dpnt_cvrd_othr_ptip_id);

Line 1173: from BEN_ELIG_DPNT_CVRD_OTHR_PTIP_F b

1169: select a.elig_dpnt_cvrd_othr_ptip_id, a.object_version_number, a.effective_end_date eed
1170: from BEN_ELIG_DPNT_CVRD_OTHR_PTIP_F a
1171: where a.eligy_prfl_id = p_eligy_prfl_id
1172: and a.effective_end_date = (select max(b.effective_end_date)
1173: from BEN_ELIG_DPNT_CVRD_OTHR_PTIP_F b
1174: where a.elig_dpnt_cvrd_othr_ptip_id = b.elig_dpnt_cvrd_othr_ptip_id);
1175:
1176: cursor BEN_ELIG_DPNT_CVRD_PLIP_F is
1177: select a.elig_dpnt_cvrd_plip_id, a.object_version_number, a.effective_end_date eed

Line 1755: for l_row in BEN_ELIG_DPNT_CVRD_OTHR_PTIP_F loop

1751: ,p_effective_date => l_effective_date
1752: ,p_datetrack_mode => p_datetrack_mode);
1753: end if;
1754: end loop;
1755: for l_row in BEN_ELIG_DPNT_CVRD_OTHR_PTIP_F loop
1756: if (p_datetrack_mode = hr_api.g_delete and l_row.eed > p_effective_date)
1757: or p_datetrack_mode <> hr_api.g_delete then
1758: if p_datetrack_mode = hr_api.g_zap then
1759: l_effective_date := l_row.eed;