7818: fetch csr_bg_start_date into l_bg_start_date;
7819: -- Modified the check condition as part of fix 5407679
7820: if csr_bg_start_date%found then
7821: if l_bg_start_date > p_rec.effective_start_date then
7822: fnd_message.set_name('PER','HR_52383_EFF_DATE_RANGE');
7823: fnd_message.raise_error;
7824: end if;
7825: end if;
7826: close csr_bg_start_date;
7819: -- Modified the check condition as part of fix 5407679
7820: if csr_bg_start_date%found then
7821: if l_bg_start_date > p_rec.effective_start_date then
7822: fnd_message.set_name('PER','HR_52383_EFF_DATE_RANGE');
7823: fnd_message.raise_error;
7824: end if;
7825: end if;
7826: close csr_bg_start_date;
7827: --