DBA Data[Home] [Help]

APPS.OKL_SLA_ACC_SOURCES_PVT dependencies on OKC_GOVERNANCES

Line 205: ,okc_governances governances

201: ,chr_cr_master.contract_number, NULL) master_lease_number
202: ,decode(chr_cr_master.scs_code,'MASTER_LEASE'
203: ,chr_cr_master.id, TO_NUMBER(NULL)) master_lease_id
204: FROM okc_k_headers_all_b chr_cr_master
205: ,okc_governances governances
206: WHERE governances.dnz_chr_id = l_khr_id
207: AND governances.chr_id_referred = chr_cr_master.ID
208: AND chr_cr_master.scs_code in ('CREDITLINE_CONTRACT', 'MASTER_LEASE');
209:

Line 215: ,okc_governances crline_gov

211: CURSOR c_creditline_sub_csr (l_mla_chr_id NUMBER)
212: IS
213: SELECT crline_sub_chr.contract_number
214: FROM okc_k_headers_all_b crline_sub_chr
215: ,okc_governances crline_gov
216: WHERE crline_gov.dnz_chr_id = l_mla_chr_id
217: AND crline_gov.chr_id_referred = crline_sub_chr.id
218: AND crline_sub_chr.scs_code = 'CREDITLINE_CONTRACT';
219: