DBA Data[Home] [Help]

APPS.OKL_CHECKLIST_PVT dependencies on OKC_K_HEADERS_B

Line 4553: CURSOR c_lease_app (p_chr_id okc_k_headers_b.id%type)

4549:
4550: ---------------------------------------------------------------------------------------------------------
4551: -- check if the contract was created from a lease application
4552: ---------------------------------------------------------------------------------------------------------
4553: CURSOR c_lease_app (p_chr_id okc_k_headers_b.id%type)
4554: IS
4555: select chr.ORIG_SYSTEM_ID1
4556: from okc_k_headers_b chr
4557: where ORIG_SYSTEM_SOURCE_CODE = G_OKL_LEASE_APP

Line 4556: from okc_k_headers_b chr

4552: ---------------------------------------------------------------------------------------------------------
4553: CURSOR c_lease_app (p_chr_id okc_k_headers_b.id%type)
4554: IS
4555: select chr.ORIG_SYSTEM_ID1
4556: from okc_k_headers_b chr
4557: where ORIG_SYSTEM_SOURCE_CODE = G_OKL_LEASE_APP
4558: and chr.id = p_chr_id
4559: ;
4560: