APPS.OKC_PAC_PVT dependencies on OKC_PRICE_ADJUSTMENTS

Line 467: FROM Okc_Price_Adjustments_V

463: item_not_found_error EXCEPTION;
464: CURSOR okc_patv_pk_csr (p_id IN NUMBER) IS
465: SELECT
466: 'x'
467: FROM Okc_Price_Adjustments_V
468: WHERE okc_price_adjustments_v.id = p_id;
469: l_okc_patv_pk okc_patv_pk_csr%ROWTYPE;
470: CURSOR okc_clev_pk_csr (p_id IN NUMBER) IS
471: SELECT

Line 468: WHERE okc_price_adjustments_v.id = p_id;

464: CURSOR okc_patv_pk_csr (p_id IN NUMBER) IS
465: SELECT
466: 'x'
467: FROM Okc_Price_Adjustments_V
468: WHERE okc_price_adjustments_v.id = p_id;
469: l_okc_patv_pk okc_patv_pk_csr%ROWTYPE;
470: CURSOR okc_clev_pk_csr (p_id IN NUMBER) IS
471: SELECT
472: 'x'

Line 2645: FROM OKC_PRICE_ADJUSTMENTS

2641:
2642: FROM okc_price_adj_assocs
2643: WHERE pat_id_from IN
2644: ( SELECT pat_id
2645: FROM OKC_PRICE_ADJUSTMENTS
2646: WHERE chr_id = p_chr_id
2647: );
2648:
2649: IF (l_debug = 'Y') THEN

Line 2733: FROM OKC_PRICE_ADJUSTMENTS

2729: object_version_number
2730: FROM okc_price_adj_assocs_h
2731: WHERE pat_id_from IN
2732: ( SELECT pat_id
2733: FROM OKC_PRICE_ADJUSTMENTS
2734: WHERE chr_id = p_chr_id
2735: )
2736: AND major_version = p_major_version;
2737: