54: fetch csr_effective_date into v_effective_date;
55: --
56: -- Stop if no session date exists (eg not being updated via a form)
57: if csr_effective_date%notfound then
58: hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');
59: hr_utility.set_message_token ('PROCEDURE','PAY_ELEMENT_LINKS_T1');
60: hr_utility.raise_error;
61: end if;
62: --
55: --
56: -- Stop if no session date exists (eg not being updated via a form)
57: if csr_effective_date%notfound then
58: hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');
59: hr_utility.set_message_token ('PROCEDURE','PAY_ELEMENT_LINKS_T1');
60: hr_utility.raise_error;
61: end if;
62: --
63: close csr_effective_date;
56: -- Stop if no session date exists (eg not being updated via a form)
57: if csr_effective_date%notfound then
58: hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');
59: hr_utility.set_message_token ('PROCEDURE','PAY_ELEMENT_LINKS_T1');
60: hr_utility.raise_error;
61: end if;
62: --
63: close csr_effective_date;
64: --