DBA Data[Home] [Help]

APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKC_GOVERNANCES

Line 28303: okc_governances gov

28299: CURSOR temp_aggr_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
28300: p_scs_code OKC_K_HEADERS_V.SCS_CODE%TYPE) IS
28301: SELECT head.id
28302: FROM okc_k_headers_v head,
28303: okc_governances gov
28304: WHERE head.id = gov.chr_id_referred
28305: AND head.scs_code = p_scs_code --'MASTER_LEASE'
28306: AND gov.dnz_chr_id = p_chr_id;
28307: