66: -- The following cursor was modified by MSENGUPT on 12/09/2001 to include rownum and FIRST_ROWS hint for perf.
67: CURSOR l_rul_csr IS
68: SELECT /*+ FIRST_ROWS */
69: 'x' 70: FROM OKC_RULES_B rul, 71: OKC_RULE_GROUPS_B rgp
72: WHERE rul.rule_information_category = p_rgrv_rec.rdf_code
73: AND rul.rgp_id = rgp.id
74: AND rgp.rgd_code = p_rgrv_rec.rgd_code
[Home] [Help]