APPS.OKC_COPY_CONTRACT_PVT dependencies on OKC_PRICE_ADJUSTMENTS_V

Line 3680: FROM okc_price_adjustments_v

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

Line 5282: FROM okc_price_adjustments_V

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

Line 8933: FROM OKC_PRICE_ADJUSTMENTS_V

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