DBA Data[Home] [Help]

APPS.OKL_CONTRACT_PVT dependencies on OKC_GOVERNANCES

Line 4408: FROM OKC_GOVERNANCES_V

4404: l_gvev_tbl_in okc_contract_pub.gvev_tbl_type;
4405:
4406: CURSOR l_gvev_csr (p_id IN NUMBER) IS
4407: SELECT ID
4408: FROM OKC_GOVERNANCES_V
4409: WHERE dnz_chr_id = p_id;
4410:
4411: Begin
4412:

Line 10163: FROM OKC_GOVERNANCES

10159:
10160: --cursor to find out chr id required to flip status at edit point
10161: CURSOR chr_id_crs (p_gve_id IN NUMBER) is
10162: SELECT DNZ_CHR_ID
10163: FROM OKC_GOVERNANCES
10164: WHERE ID = P_GVE_ID;
10165:
10166: l_dnz_chr_id OKC_GOVERNANCES.dnz_chr_id%TYPE;
10167: BEGIN

Line 10166: l_dnz_chr_id OKC_GOVERNANCES.dnz_chr_id%TYPE;

10162: SELECT DNZ_CHR_ID
10163: FROM OKC_GOVERNANCES
10164: WHERE ID = P_GVE_ID;
10165:
10166: l_dnz_chr_id OKC_GOVERNANCES.dnz_chr_id%TYPE;
10167: BEGIN
10168:
10169: -- call START_ACTIVITY to create savepoint, check compatibility
10170: -- and initialize message list