APPS.OKL_CREDIT_CHECKLIST_PVT dependencies on OKC_RULES_B

Line 544: OKC_RULES_B rulh

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;

Line 764: from okc_rules_b

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:

Line 1465: from okc_rules_b a

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:

Line 1989: from okc_rules_b a

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: