APPS.OKL_QA_SECURITIZATION dependencies on OKL_K_HEADERS

Line 90: CURSOR l_hdr_csr(chrid OKL_K_HEADERS.KHR_ID%TYPE) IS

86: and crg.RGD_CODE like rgcode
87: and crl.RULE_INFORMATION_CATEGORY = rlcat
88: and crg.dnz_chr_id = chrId;
89:
90: CURSOR l_hdr_csr(chrid OKL_K_HEADERS.KHR_ID%TYPE) IS
91: SELECT chr.SCS_CODE,
92: chr.START_DATE,
93: chr.DATE_SIGNED,
94: chr.CURRENCY_CODE,

Line 101: FROM OKC_K_HEADERS_B chr, OKL_K_HEADERS khr

97: khr.accepted_date,
98: khr.DEAL_TYPE,
99: khr.term_duration term,
100: khr.after_tax_yield
101: FROM OKC_K_HEADERS_B chr, OKL_K_HEADERS khr
102: WHERE chr.id = chrid
103: AND chr.id = khr.id;
104:
105: CURSOR l_lne_csr1(ltycode VARCHAR2, chrid OKL_K_HEADERS.KHR_ID%TYPE) IS

Line 105: CURSOR l_lne_csr1(ltycode VARCHAR2, chrid OKL_K_HEADERS.KHR_ID%TYPE) IS

101: FROM OKC_K_HEADERS_B chr, OKL_K_HEADERS khr
102: WHERE chr.id = chrid
103: AND chr.id = khr.id;
104:
105: CURSOR l_lne_csr1(ltycode VARCHAR2, chrid OKL_K_HEADERS.KHR_ID%TYPE) IS
106: SELECT kle.name,
107: kle.CURRENCY_CODE,
108: kle.id,
109: kle.cle_id,

Line 127: CURSOR l_lne_csr(ltycode VARCHAR2, chrid OKL_K_HEADERS.KHR_ID%TYPE) IS

123: AND kle.dnz_chr_id = chrid
124: AND sts.code = kle.sts_code
125: AND sts.ste_code not in ( 'HOLD', 'TERMINATED', 'EXPIRED', 'CANCELLED');
126:
127: CURSOR l_lne_csr(ltycode VARCHAR2, chrid OKL_K_HEADERS.KHR_ID%TYPE) IS
128: SELECT kle.name,
129: kle.CURRENCY_CODE,
130: kle.id,
131: kle.cle_id,