540:
541: cursor c_date(p_id number)
542: is select 1
543: FROM
544: OKC_RULES_B rulh
545: where rulh.RULE_INFORMATION1 is not null
546: and trunc(FND_DATE.CANONICAL_TO_DATE(rulh.RULE_INFORMATION1)) > trunc(FND_DATE.CANONICAL_TO_DATE(rulh.RULE_INFORMATION2))
547: --and rulh.rule_information_category = 'LACLFM'
548: and rulh.id = p_id;
760:
761: cursor c_obj_id (chr_id number)
762: is
763: select id
764: from okc_rules_b
765: where RULE_INFORMATION_CATEGORY = G_CREDIT_CHKLST_TPL_RULE4--'LACLFM'
766: and dnz_chr_id = chr_id;
767:
768:
1461:
1462: cursor c_ids (p_chr_id okc_k_headers_b.id%TYPE)
1463: is
1464: select a.id
1465: from okc_rules_b a
1466: where a.dnz_chr_id = p_chr_id
1467: and a.RULE_INFORMATION_CATEGORY = G_CREDIT_CHKLST_TPL_RULE2--'LACCLD'
1468: ;
1469:
1985:
1986: cursor c_tpl_hdr (p_chr_id okc_k_headers_b.id%TYPE)
1987: is
1988: select a.id
1989: from okc_rules_b a
1990: where a.dnz_chr_id = p_chr_id
1991: and a.RULE_INFORMATION_CATEGORY = G_CREDIT_CHKLST_TPL_RULE4--'LACLFM'
1992: ;
1993: