DBA Data[Home] [Help]

APPS.OKC_COPY_CONTRACT_PVT dependencies on OKC_PRICE_ADJ_ASSOCS_V

Line 3688: FROM okc_price_adj_assocs_v

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

Line 5296: FROM okc_price_adj_assocs_v

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

Line 9050: FROM OKC_PRICE_ADJ_ASSOCS_V

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