530:
531: -- Get rule description
532: CURSOR l_rule_csr (cp_rule_code VARCHAR2) IS
533: SELECT rd.meaning
534: FROM okc_rule_defs_v rd
535: WHERE rd.application_id = 540
536: AND rd.rule_code = cp_rule_code;
537:
538: l_lookup_type fnd_lookups.lookup_type%TYPE := NULL;
901:
902: -- Get rule description
903: CURSOR l_rule_csr (cp_rule_code VARCHAR2) IS
904: SELECT rd.meaning
905: FROM okc_rule_defs_v rd
906: WHERE rd.application_id = 540
907: AND rd.rule_code = cp_rule_code;
908:
909: l_rule_meaning okc_rule_defs_v.meaning%TYPE;
905: FROM okc_rule_defs_v rd
906: WHERE rd.application_id = 540
907: AND rd.rule_code = cp_rule_code;
908:
909: l_rule_meaning okc_rule_defs_v.meaning%TYPE;
910: l_group_meaning fnd_lookups.meaning%TYPE;
911: l_label_value VARCHAR2(2000) := NULL;
912:
913: BEGIN