APPS.OKL_SETUPPOVALUES_PVT dependencies on OKL_PDT_QUALITYS_V

Line 151: CURSOR okl_pov_constraints_csr(p_ove_id IN Okl_Pdt_Qualitys_V.ID%TYPE,

147: WHERE pdt.id = pon.pdt_id
148: AND pon.ID = p_pon_id
149: AND NVL(pdt.TO_DATE, p_date) < p_date;
150:
151: CURSOR okl_pov_constraints_csr(p_ove_id IN Okl_Pdt_Qualitys_V.ID%TYPE,
152: p_from_date IN Okl_Pdt_Qualitys_V.FROM_DATE%TYPE,
153: p_to_date IN Okl_Pdt_Qualitys_V.TO_DATE%TYPE
154: ) IS
155: SELECT '1'

Line 152: p_from_date IN Okl_Pdt_Qualitys_V.FROM_DATE%TYPE,

148: AND pon.ID = p_pon_id
149: AND NVL(pdt.TO_DATE, p_date) < p_date;
150:
151: CURSOR okl_pov_constraints_csr(p_ove_id IN Okl_Pdt_Qualitys_V.ID%TYPE,
152: p_from_date IN Okl_Pdt_Qualitys_V.FROM_DATE%TYPE,
153: p_to_date IN Okl_Pdt_Qualitys_V.TO_DATE%TYPE
154: ) IS
155: SELECT '1'
156: FROM Okl_Opt_Values_V ove

Line 153: p_to_date IN Okl_Pdt_Qualitys_V.TO_DATE%TYPE

149: AND NVL(pdt.TO_DATE, p_date) < p_date;
150:
151: CURSOR okl_pov_constraints_csr(p_ove_id IN Okl_Pdt_Qualitys_V.ID%TYPE,
152: p_from_date IN Okl_Pdt_Qualitys_V.FROM_DATE%TYPE,
153: p_to_date IN Okl_Pdt_Qualitys_V.TO_DATE%TYPE
154: ) IS
155: SELECT '1'
156: FROM Okl_Opt_Values_V ove
157: WHERE ove.ID = p_ove_id