APPS.OKC_COPY_CONTRACT_PVT dependencies on OKC_PRICE_ADJUSTMENTS

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 5288: FROM okc_price_adjustments_HV

5284: AND cle_id IS NULL -- Added for Bug 2027165
5285: AND G_COPY_HISTORY_YN = 'N'
5286: UNION ALL
5287: SELECT id
5288: FROM okc_price_adjustments_HV
5289: WHERE chr_id = p_from_chr_id
5290: AND cle_id IS NULL -- Added for Bug 2027165
5291: AND major_version = G_FROM_VERSION_NUMBER
5292: AND G_COPY_HISTORY_YN = 'Y';

Line 5300: FROM OKC_PRICE_ADJUSTMENTS

5296: FROM okc_price_adj_assocs_v
5297: WHERE
5298: pat_id_from IN
5299: ( SELECT id
5300: FROM OKC_PRICE_ADJUSTMENTS
5301: WHERE chr_id = p_from_chr_id)
5302: AND G_COPY_HISTORY_YN = 'N'
5303: UNION ALL
5304: SELECT id

Line 5309: FROM OKC_PRICE_ADJUSTMENTS

5305: FROM okc_price_adj_assocs_HV
5306: WHERE
5307: pat_id_from IN
5308: ( SELECT id
5309: FROM OKC_PRICE_ADJUSTMENTS
5310: WHERE chr_id = p_from_chr_id)
5311: AND major_version = G_FROM_VERSION_NUMBER
5312: AND G_COPY_HISTORY_YN = 'Y';
5313: -------------------------------------------

Line 5320: FROM OKC_PRICE_ADJUSTMENTS

5316: FROM okc_price_adj_attribs_v
5317: WHERE
5318: pat_id IN
5319: ( SELECT pat_id
5320: FROM OKC_PRICE_ADJUSTMENTS
5321: WHERE
5322: chr_id = p_from_chr_id);
5323: */
5324:

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