DBA Data[Home] [Help]

APPS.OKC_COPY_CONTRACT_PVT dependencies on OKC_GOVERNANCES_V

Line 1415: FROM okc_governances_v

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

Line 3719: FROM okc_governances_v

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

Line 5345: FROM okc_governances_v

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