DBA Data[Home] [Help]

APPS.OKC_COPY_CONTRACT_PVT dependencies on OKC_K_SALES_CREDITS_V

Line 2087: FROM OKC_K_SALES_CREDITS_V

2083: CREATED_BY,
2084: CREATION_DATE,
2085: LAST_UPDATED_BY,
2086: LAST_UPDATE_DATE
2087: FROM OKC_K_SALES_CREDITS_V
2088: WHERE ID = p_scrv_id;
2089: BEGIN
2090: OPEN c_scrv_rec;
2091: FETCH c_scrv_rec

Line 3700: FROM okc_k_sales_credits_v

3696:
3697: -- cursor for sales credits
3698: CURSOR c_scrv IS
3699: SELECT id
3700: FROM okc_k_sales_credits_v
3701: WHERE cle_id = p_from_cle_id
3702: AND G_COPY_HISTORY_YN = 'N'
3703: UNION ALL
3704: SELECT id

Line 5328: FROM okc_k_sales_credits_v

5324:
5325: -- cursor for sales credits
5326: CURSOR c_scrv IS
5327: SELECT id
5328: FROM okc_k_sales_credits_v
5329: WHERE dnz_chr_id = p_from_chr_id
5330: AND cle_id IS NULL
5331: AND G_COPY_HISTORY_YN = 'N'
5332: UNION ALL