DBA Data[Home] [Help]

APPS.BEN_DT_TRGR_HANDLE dependencies on BEN_ECD_LER

Line 1183: l_old_rec ben_ecd_ler.g_ecd_ler_rec;

1179: ,ovrdn_thru_dt
1180: from ben_elig_cvrd_dpnt_f
1181: where rowid = p_rowid;
1182: --
1183: l_old_rec ben_ecd_ler.g_ecd_ler_rec;
1184: l_new_rec ben_ecd_ler.g_ecd_ler_rec;
1185: --
1186: begin
1187: --

Line 1184: l_new_rec ben_ecd_ler.g_ecd_ler_rec;

1180: from ben_elig_cvrd_dpnt_f
1181: where rowid = p_rowid;
1182: --
1183: l_old_rec ben_ecd_ler.g_ecd_ler_rec;
1184: l_new_rec ben_ecd_ler.g_ecd_ler_rec;
1185: --
1186: begin
1187: --
1188: g_debug := hr_utility.debug_enabled;

Line 1208: ben_ecd_ler.ler_chk(l_old_rec,l_new_rec,p_effective_start_date );

1204: l_new_rec.cvg_thru_dt := p_cvg_thru_dt;
1205: l_new_rec.ovrdn_flag := p_ovrdn_flag;
1206: l_new_rec.ovrdn_thru_dt := p_ovrdn_thru_dt;
1207: --
1208: ben_ecd_ler.ler_chk(l_old_rec,l_new_rec,p_effective_start_date );
1209: if g_debug then
1210: hr_utility.set_location('Leaving:'|| l_proc, 100);
1211: end if;
1212: end if;

Line 1248: l_old_rec ben_ecd_ler.g_ecd_ler_rec;

1244: ,ovrdn_thru_dt
1245: from ben_elig_cvrd_dpnt_f
1246: where rowid = p_rowid;
1247: --
1248: l_old_rec ben_ecd_ler.g_ecd_ler_rec;
1249: l_new_rec ben_ecd_ler.g_ecd_ler_rec;
1250: --
1251: begin
1252: --

Line 1249: l_new_rec ben_ecd_ler.g_ecd_ler_rec;

1245: from ben_elig_cvrd_dpnt_f
1246: where rowid = p_rowid;
1247: --
1248: l_old_rec ben_ecd_ler.g_ecd_ler_rec;
1249: l_new_rec ben_ecd_ler.g_ecd_ler_rec;
1250: --
1251: begin
1252: --
1253: --

Line 1276: ben_ecd_ler.ler_chk(l_old_rec,l_new_rec,p_effective_start_date );

1272: l_new_rec.ovrdn_thru_dt := p_ovrdn_thru_dt;
1273: l_new_rec.elig_cvrd_dpnt_id := p_elig_cvrd_dpnt_id;
1274: -- 9999 l_new_rec.elig_cvrd_dpnt_id := l_old_rec.elig_cvrd_dpnt_id;
1275: --
1276: ben_ecd_ler.ler_chk(l_old_rec,l_new_rec,p_effective_start_date );
1277: if g_debug then
1278: hr_utility.set_location('Leaving:'|| l_proc, 100);
1279: end if;
1280: end if;