APPS.OKC_PAA_PVT dependencies on OKC_PRICE_ADJUSTMENTS

Line 656: FROM Okc_Price_Adjustments_V

652: item_not_found_error EXCEPTION;
653: CURSOR okc_patv_pk_csr (p_id IN NUMBER) IS
654: SELECT
655: 'x'
656: FROM Okc_Price_Adjustments_V
657: WHERE okc_price_adjustments_v.id = p_id;
658: l_okc_patv_pk okc_patv_pk_csr%ROWTYPE;
659: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
660: l_row_notfound BOOLEAN := TRUE;

Line 657: WHERE okc_price_adjustments_v.id = p_id;

653: CURSOR okc_patv_pk_csr (p_id IN NUMBER) IS
654: SELECT
655: 'x'
656: FROM Okc_Price_Adjustments_V
657: WHERE okc_price_adjustments_v.id = p_id;
658: l_okc_patv_pk okc_patv_pk_csr%ROWTYPE;
659: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
660: l_row_notfound BOOLEAN := TRUE;
661: BEGIN

Line 2813: FROM OKC_PRICE_ADJUSTMENTS

2809: p_major_version
2810: FROM okc_price_adj_attribs
2811: WHERE pat_id IN
2812: ( SELECT pat_id
2813: FROM OKC_PRICE_ADJUSTMENTS
2814: WHERE chr_id = p_chr_id
2815: );
2816:
2817: IF (l_debug = 'Y') THEN

Line 2905: FROM OKC_PRICE_ADJUSTMENTS

2901: object_version_number
2902: FROM okc_price_adj_attribs_h
2903: WHERE pat_id IN
2904: ( SELECT pat_id
2905: FROM OKC_PRICE_ADJUSTMENTS
2906: WHERE chr_id = p_chr_id
2907: )
2908: AND major_version = p_major_version;
2909: