APPS.OKL_SETUPOVERULES_PVT dependencies on OKL_OPT_VALUES_V

Line 88: CURSOR okl_ovd_orl_fk_csr (p_ove_id IN Okl_Opt_Values_V.ID%TYPE,

84: p_ovdv_rec IN ovdv_rec_type,
85: x_return_status OUT NOCOPY VARCHAR2,
86: x_valid OUT NOCOPY BOOLEAN
87: ) IS
88: CURSOR okl_ovd_orl_fk_csr (p_ove_id IN Okl_Opt_Values_V.ID%TYPE,
89: p_orl_id IN Okl_Opt_Rules_V.id%TYPE
90: ) IS
91: SELECT '1'
92: FROM Okl_Opt_Values_V ove,

Line 92: FROM Okl_Opt_Values_V ove,

88: CURSOR okl_ovd_orl_fk_csr (p_ove_id IN Okl_Opt_Values_V.ID%TYPE,
89: p_orl_id IN Okl_Opt_Rules_V.id%TYPE
90: ) IS
91: SELECT '1'
92: FROM Okl_Opt_Values_V ove,
93: Okl_Opt_Rules_V orl,
94: Okl_Lse_Scs_Rules_V lsr
95: WHERE orl.ID = p_orl_id
96: AND ove.ID = p_ove_id

Line 109: CURSOR okl_ovd_csp_fk_csr (p_ove_id IN Okl_Opt_Values_V.ID%TYPE

105: AND lsr.RULE = orl.RGR_RDF_CODE
106: AND (lsr.START_DATE > ove.FROM_DATE OR
107: NVL(lsr.END_DATE, NVL(ove.TO_DATE, Okl_Api.G_MISS_DATE)) < NVL(ove.TO_DATE, Okl_Api.G_MISS_DATE));
108:
109: CURSOR okl_ovd_csp_fk_csr (p_ove_id IN Okl_Opt_Values_V.ID%TYPE
110: ) IS
111: SELECT '1'
112: FROM Okl_Pdt_Opt_Vals_V pov,
113: Okl_Slctd_Optns_V csp

Line 121: FROM Okl_opt_values_V ove

117: CURSOR okl_ovd_ove_fk_csr (p_ove_id IN Okl_Products_V.ID%TYPE,
118: p_date IN Okl_Products_V.TO_DATE%TYPE
119: ) IS
120: SELECT '1'
121: FROM Okl_opt_values_V ove
122: WHERE ove.ID = p_ove_id
123: AND NVL(ove.TO_DATE, p_date) < p_date;
124:
125: