DBA Data[Home] [Help]

APPS.OKL_CONTRACT_PVT dependencies on OKC_GOVERNANCES

Line 4323: FROM OKC_GOVERNANCES_V

4319: l_gvev_tbl_in okc_contract_pub.gvev_tbl_type;
4320:
4321: CURSOR l_gvev_csr (p_id IN NUMBER) IS
4322: SELECT ID
4323: FROM OKC_GOVERNANCES_V
4324: WHERE dnz_chr_id = p_id;
4325:
4326: Begin
4327:

Line 10061: FROM OKC_GOVERNANCES

10057:
10058: --cursor to find out chr id required to flip status at edit point
10059: CURSOR chr_id_crs (p_gve_id IN NUMBER) is
10060: SELECT DNZ_CHR_ID
10061: FROM OKC_GOVERNANCES
10062: WHERE ID = P_GVE_ID;
10063:
10064: l_dnz_chr_id OKC_GOVERNANCES.dnz_chr_id%TYPE;
10065: BEGIN

Line 10064: l_dnz_chr_id OKC_GOVERNANCES.dnz_chr_id%TYPE;

10060: SELECT DNZ_CHR_ID
10061: FROM OKC_GOVERNANCES
10062: WHERE ID = P_GVE_ID;
10063:
10064: l_dnz_chr_id OKC_GOVERNANCES.dnz_chr_id%TYPE;
10065: BEGIN
10066:
10067: -- call START_ACTIVITY to create savepoint, check compatibility
10068: -- and initialize message list