APPS.OKC_COPY_CONTRACT_PVT dependencies on OKC_PRICE_ADJUSTMENTS

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

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

Line 5301: FROM OKC_PRICE_ADJUSTMENTS

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

Line 5310: FROM OKC_PRICE_ADJUSTMENTS

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

Line 5321: FROM OKC_PRICE_ADJUSTMENTS

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

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