DBA Data[Home] [Help]

APPS.OKC_COPY_CONTRACT_PVT dependencies on OKC_PRICE_ADJ_ASSOCS_V

Line 3689: FROM okc_price_adj_assocs_v

3685: -- Added 'chr_id IS NOT NULL ' for Bug 2027165
3686:
3687: CURSOR c_pacv IS
3688: SELECT id
3689: FROM okc_price_adj_assocs_v
3690: WHERE cle_id = p_from_cle_id;
3691:
3692: /* CURSOR c_paav IS
3693: SELECT id

Line 5297: FROM okc_price_adj_assocs_v

5293: AND G_COPY_HISTORY_YN = 'Y';
5294: -----------------------------------
5295: CURSOR c_pacv IS
5296: SELECT id
5297: FROM okc_price_adj_assocs_v
5298: WHERE
5299: pat_id_from IN
5300: ( SELECT id
5301: FROM OKC_PRICE_ADJUSTMENTS

Line 9051: FROM OKC_PRICE_ADJ_ASSOCS_V

9047: PROGRAM_ID,
9048: PROGRAM_UPDATE_DATE,
9049: REQUEST_ID,
9050: OBJECT_VERSION_NUMBER
9051: FROM OKC_PRICE_ADJ_ASSOCS_V
9052: WHERE ID = p_pac_id;
9053: BEGIN
9054: OPEN c_pacv_rec;
9055: FETCH c_pacv_rec