APPS.OKL_SETUPTQYVALUES_PVT dependencies on OKL_PTL_QUALITYS_V

Line 83: FROM Okl_ptl_qualitys_V ptq

79: ) IS
80: CURSOR okl_ptqv_pk_csr (p_ptq_id IN NUMBER) IS
81: SELECT FROM_DATE,
82: TO_DATE
83: FROM Okl_ptl_qualitys_V ptq
84: WHERE ptq.id = p_ptq_id;
85: l_okl_ptqv_pk okl_ptqv_pk_csr%ROWTYPE;
86: l_ptqv_rec ptqv_rec_type;
87: BEGIN

Line 132: FROM okl_ptl_qualitys_v ptqv

128: p_from_date DATE,
129: p_to_date DATE
130: ) IS
131: SELECT '1'
132: FROM okl_ptl_qualitys_v ptqv
133: WHERE ptqv.ID = p_ptq_id
134: AND ((ptqv.FROM_DATE > p_from_date OR
135: p_from_date > NVL(ptqv.TO_DATE,p_from_date) OR
136: NVL(ptqv.TO_DATE, p_to_date) < p_to_date));