DBA Data[Home] [Help]

APPS.BEN_DT_TRGR_HANDLE dependencies on BEN_ECD_LER

Line 1107: l_old_rec ben_ecd_ler.g_ecd_ler_rec;

1103: ,ovrdn_thru_dt
1104: from ben_elig_cvrd_dpnt_f
1105: where rowid = p_rowid;
1106: --
1107: l_old_rec ben_ecd_ler.g_ecd_ler_rec;
1108: l_new_rec ben_ecd_ler.g_ecd_ler_rec;
1109: --
1110: begin
1111: --

Line 1108: l_new_rec ben_ecd_ler.g_ecd_ler_rec;

1104: from ben_elig_cvrd_dpnt_f
1105: where rowid = p_rowid;
1106: --
1107: l_old_rec ben_ecd_ler.g_ecd_ler_rec;
1108: l_new_rec ben_ecd_ler.g_ecd_ler_rec;
1109: --
1110: begin
1111: --
1112: g_debug := hr_utility.debug_enabled;

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

1128: l_new_rec.cvg_thru_dt := p_cvg_thru_dt;
1129: l_new_rec.ovrdn_flag := p_ovrdn_flag;
1130: l_new_rec.ovrdn_thru_dt := p_ovrdn_thru_dt;
1131: --
1132: ben_ecd_ler.ler_chk(l_old_rec,l_new_rec,p_effective_start_date );
1133: if g_debug then
1134: hr_utility.set_location('Leaving:'|| l_proc, 100);
1135: end if;
1136: end if;

Line 1172: l_old_rec ben_ecd_ler.g_ecd_ler_rec;

1168: ,ovrdn_thru_dt
1169: from ben_elig_cvrd_dpnt_f
1170: where rowid = p_rowid;
1171: --
1172: l_old_rec ben_ecd_ler.g_ecd_ler_rec;
1173: l_new_rec ben_ecd_ler.g_ecd_ler_rec;
1174: --
1175: begin
1176: --

Line 1173: l_new_rec ben_ecd_ler.g_ecd_ler_rec;

1169: from ben_elig_cvrd_dpnt_f
1170: where rowid = p_rowid;
1171: --
1172: l_old_rec ben_ecd_ler.g_ecd_ler_rec;
1173: l_new_rec ben_ecd_ler.g_ecd_ler_rec;
1174: --
1175: begin
1176: --
1177: --

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

1196: l_new_rec.ovrdn_thru_dt := p_ovrdn_thru_dt;
1197: l_new_rec.elig_cvrd_dpnt_id := p_elig_cvrd_dpnt_id;
1198: -- 9999 l_new_rec.elig_cvrd_dpnt_id := l_old_rec.elig_cvrd_dpnt_id;
1199: --
1200: ben_ecd_ler.ler_chk(l_old_rec,l_new_rec,p_effective_start_date );
1201: if g_debug then
1202: hr_utility.set_location('Leaving:'|| l_proc, 100);
1203: end if;
1204: end if;