DBA Data[Home] [Help]

APPS.OKC_COPY_CONTRACT_PVT dependencies on OKC_GOVERNANCES_V

Line 1414: FROM okc_governances_v

1410: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1411:
1412: CURSOR c_governances IS
1413: SELECT id
1414: FROM okc_governances_v
1415: WHERE dnz_chr_id = p_from_chr_id
1416: AND cle_id is null;
1417:
1418: ----------------------------------------------------------------------------

Line 3718: FROM okc_governances_v

3714:
3715: -- cursor for governances
3716: CURSOR c_governances IS
3717: SELECT id
3718: FROM okc_governances_v
3719: WHERE cle_id = p_from_cle_id
3720: AND G_COPY_HISTORY_YN = 'N'
3721: UNION ALL
3722: SELECT id

Line 5344: FROM okc_governances_v

5340: --
5341: -- cursor for goverances
5342: CURSOR c_governances IS
5343: SELECT id
5344: FROM okc_governances_v
5345: WHERE dnz_chr_id = p_from_chr_id
5346: AND cle_id is null
5347: AND G_COPY_HISTORY_YN = 'N'
5348: UNION ALL