277: -- cursor to check that not more than one rule is entered per application
278: --
279: CURSOR csr_chk_application IS
280: SELECT 'error' 281: FROM sys.dual 282: WHERE EXISTS (
283: SELECT 'x'
284: FROM hxc_retrieval_rule_comps rtc
285: WHERE rtc.time_recipient_id = p_time_recipient_id