APPS.OKC_COPY_CONTRACT_PVT dependencies on OKC_PRICE_ADJUSTMENTS_V

Line 3681: FROM okc_price_adjustments_v

3677: WHERE cle_id = p_from_cle_id;
3678:
3679: CURSOR c_patv IS
3680: SELECT id
3681: FROM okc_price_adjustments_v
3682: WHERE cle_id = p_from_cle_id;
3683: -- Commented 'chr_id IS NOT NULL' as per Bug 2143018
3684: --AND chr_id IS NOT NULL;
3685: -- Added 'chr_id IS NOT NULL ' for Bug 2027165

Line 5283: FROM okc_price_adjustments_V

5279: AND G_COPY_HISTORY_YN = 'Y';
5280: -----------------------------------
5281: CURSOR c_patv IS
5282: SELECT id
5283: FROM okc_price_adjustments_V
5284: WHERE chr_id = p_from_chr_id
5285: AND cle_id IS NULL -- Added for Bug 2027165
5286: AND G_COPY_HISTORY_YN = 'N'
5287: UNION ALL

Line 8934: FROM OKC_PRICE_ADJUSTMENTS_V

8930: ATTRIBUTE14,
8931: ATTRIBUTE15,
8932: LAST_UPDATE_LOGIN,
8933: REBATE_TRANSACTION_TYPE_CODE
8934: FROM OKC_PRICE_ADJUSTMENTS_V
8935: WHERE ID = p_pat_id;
8936: BEGIN
8937: OPEN c_patv_rec;
8938: FETCH c_patv_rec