APPS.OKL_SETUPPMVALUES_PVT dependencies on OKL_PTQ_VALUES_V

Line 153: CURSOR okl_pmv_constraints_csr (p_ptv_id IN Okl_Ptq_Values_V.ID%TYPE,

149: FROM Okl_pdt_templates_V ptl
150: WHERE ptl.ID = p_ptl_id
151: AND NVL(ptl.TO_DATE, p_date) < p_date;
152:
153: CURSOR okl_pmv_constraints_csr (p_ptv_id IN Okl_Ptq_Values_V.ID%TYPE,
154: p_from_date IN Okl_Ptq_Values_V.FROM_DATE%TYPE,
155: p_to_date IN Okl_Ptq_Values_V.TO_DATE%TYPE
156: ) IS
157: SELECT '1'

Line 154: p_from_date IN Okl_Ptq_Values_V.FROM_DATE%TYPE,

150: WHERE ptl.ID = p_ptl_id
151: AND NVL(ptl.TO_DATE, p_date) < p_date;
152:
153: CURSOR okl_pmv_constraints_csr (p_ptv_id IN Okl_Ptq_Values_V.ID%TYPE,
154: p_from_date IN Okl_Ptq_Values_V.FROM_DATE%TYPE,
155: p_to_date IN Okl_Ptq_Values_V.TO_DATE%TYPE
156: ) IS
157: SELECT '1'
158: FROM Okl_Ptq_Values_V ptv

Line 155: p_to_date IN Okl_Ptq_Values_V.TO_DATE%TYPE

151: AND NVL(ptl.TO_DATE, p_date) < p_date;
152:
153: CURSOR okl_pmv_constraints_csr (p_ptv_id IN Okl_Ptq_Values_V.ID%TYPE,
154: p_from_date IN Okl_Ptq_Values_V.FROM_DATE%TYPE,
155: p_to_date IN Okl_Ptq_Values_V.TO_DATE%TYPE
156: ) IS
157: SELECT '1'
158: FROM Okl_Ptq_Values_V ptv
159: WHERE ptv.ID = p_ptv_id

Line 158: FROM Okl_Ptq_Values_V ptv

154: p_from_date IN Okl_Ptq_Values_V.FROM_DATE%TYPE,
155: p_to_date IN Okl_Ptq_Values_V.TO_DATE%TYPE
156: ) IS
157: SELECT '1'
158: FROM Okl_Ptq_Values_V ptv
159: WHERE ptv.ID = p_ptv_id
160: AND ((ptv.FROM_DATE > p_from_date OR
161: p_from_date > NVL(ptv.TO_DATE,p_from_date)) OR
162: NVL(ptv.TO_DATE, p_to_date) < p_to_date);