451: --
452: -- ----------------------------------------------------------------------------
453: Procedure chk_retr_as_unique
454: (
455: p_retrieval_rule_id in hxc_retrieval_rules.retrieval_rule_id%TYPE
456: ) IS
457: --
458: l_proc varchar2(72);
459: --
464: FROM sys.dual
465: WHERE EXISTS (select a
466: from (
467: select rc.retrieval_rule_id a,count(*) CNT
468: from hxc_retrieval_rule_comps rc, hxc_retrieval_rules rr
469: where rr.RETRIEVAL_PROCESS_ID = (select RETRIEVAL_PROCESS_ID
470: from hxc_retrieval_rules
471: where retrieval_rule_id=p_retrieval_rule_id)
472: and rr.retrieval_rule_id <> p_retrieval_rule_id
466: from (
467: select rc.retrieval_rule_id a,count(*) CNT
468: from hxc_retrieval_rule_comps rc, hxc_retrieval_rules rr
469: where rr.RETRIEVAL_PROCESS_ID = (select RETRIEVAL_PROCESS_ID
470: from hxc_retrieval_rules
471: where retrieval_rule_id=p_retrieval_rule_id)
472: and rr.retrieval_rule_id <> p_retrieval_rule_id
473: and rc.retrieval_rule_id <> p_retrieval_rule_id
474: and rc.retrieval_rule_id = rr.retrieval_rule_id