APPS.OKL_VP_COPY_CONTRACT_PVT dependencies on OKC_GOVERNANCES

Line 19: --Procedure copy_governances - Makes a copy of the okc_governances.

15:
16: G_VENDOR_PROGRAM_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'VENDOR_PROGRAM';
17:
18: --------------------------------------------------------------------------
19: --Procedure copy_governances - Makes a copy of the okc_governances.
20: --------------------------------------------------------------------------
21: PROCEDURE copy_governances(
22: p_api_version IN NUMBER,
23: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

Line 36: FROM okc_governances_v

32: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
33:
34: CURSOR c_governances IS
35: SELECT id
36: FROM okc_governances_v
37: WHERE dnz_chr_id = p_from_chr_id
38: AND cle_id is null;
39:
40: ----------------------------------------------------------------------------

Line 57: FROM OKC_GOVERNANCES

53: CLE_ID,
54: CHR_ID_REFERRED,
55: CLE_ID_REFERRED,
56: COPIED_ONLY_YN
57: FROM OKC_GOVERNANCES
58: WHERE ID = p_gve_id;
59: BEGIN
60: OPEN c_gvev_rec;
61: FETCH c_gvev_rec

Line 224: FROM okc_governances_v

220:
221:
222: CURSOR count_governances(p_from_chr_id number) IS
223: SELECT id
224: FROM okc_governances_v
225: WHERE dnz_chr_id = p_from_chr_id;
226:
227: CURSOR l_chr_csr2(contract_no varchar2,contract_no_modifier varchar2) IS
228: SELECT 'x'