APPS.OKL_QA_SECURITIZATION dependencies on OKC_RULE_GROUPS_B

Line 50: cursor l_lnerl_csr( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,

46: ---------------------------------------------------------------------------
47: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_QA_SECURITIZATION';
48: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
49: ---------------------------------------------------------------------------
50: cursor l_lnerl_csr( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
51: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
52: chrId NUMBER,
53: cleId NUMBER ) IS
54: select crl.id slh_id,

Line 62: from OKC_RULE_GROUPS_B crg,

58: crl.RULE_INFORMATION3,
59: crl.RULE_INFORMATION5,
60: crl.RULE_INFORMATION6,
61: crl.RULE_INFORMATION10
62: from OKC_RULE_GROUPS_B crg,
63: OKC_RULES_B crl
64: where crl.rgp_id = crg.id
65: and crg.RGD_CODE = rgcode
66: and crl.RULE_INFORMATION_CATEGORY = rlcat

Line 71: cursor l_hdrrl_csr( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,

67: and crg.dnz_chr_id = chrId
68: and crg.cle_id = cleId
69: order by crl.RULE_INFORMATION1;
70:
71: cursor l_hdrrl_csr( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
72: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
73: chrId NUMBER) IS
74: select crl.object1_id1,
75: crl.RULE_INFORMATION1,

Line 83: from OKC_RULE_GROUPS_B crg,

79: crl.RULE_INFORMATION5,
80: crl.RULE_INFORMATION6,
81: crl.RULE_INFORMATION10,
82: crl.RULE_INFORMATION11
83: from OKC_RULE_GROUPS_B crg,
84: OKC_RULES_B crl
85: where crl.rgp_id = crg.id
86: and crg.RGD_CODE like rgcode
87: and crl.RULE_INFORMATION_CATEGORY = rlcat