APPS.OKL_SETUPOVDTEMPLATES_PVT dependencies on OKL_OPV_RULES_V

Line 123: CURSOR okl_ovt_csp_fk_csr (p_ovd_id IN Okl_Opv_Rules_V.ID%TYPE

119: x_msg_count OUT NOCOPY NUMBER,
120: x_msg_data OUT NOCOPY VARCHAR2,
121: x_valid OUT NOCOPY BOOLEAN
122: ) IS
123: CURSOR okl_ovt_csp_fk_csr (p_ovd_id IN Okl_Opv_Rules_V.ID%TYPE
124: ) IS
125: SELECT '1'
126: FROM Okl_Opv_Rules_V ovd,
127: Okl_Pdt_Opt_Vals_V pov,

Line 126: FROM Okl_Opv_Rules_V ovd,

122: ) IS
123: CURSOR okl_ovt_csp_fk_csr (p_ovd_id IN Okl_Opv_Rules_V.ID%TYPE
124: ) IS
125: SELECT '1'
126: FROM Okl_Opv_Rules_V ovd,
127: Okl_Pdt_Opt_Vals_V pov,
128: Okl_Slctd_Optns_V csp
129: WHERE ovd.ID = p_ovd_id
130: AND pov.OVE_ID = ovd.OVE_ID

Line 133: CURSOR okl_ovt_lsr_fk_csr (p_ovd_id IN Okl_Opv_Rules_V.ID%TYPE

129: WHERE ovd.ID = p_ovd_id
130: AND pov.OVE_ID = ovd.OVE_ID
131: AND csp.POV_ID = pov.ID;
132:
133: CURSOR okl_ovt_lsr_fk_csr (p_ovd_id IN Okl_Opv_Rules_V.ID%TYPE
134: ) IS
135: SELECT orl.RGR_RGD_CODE RGR_RGD_CODE,
136: orl.RGR_RDF_CODE RGR_RDF_CODE,
137: NVL(ovd.CONTEXT_INTENT, Okl_Api.G_MISS_CHAR) CONTEXT_INTENT,

Line 143: FROM Okl_Opv_Rules_V ovd,

139: NVL(ovd.CONTEXT_INV_ORG, Okl_Api.G_MISS_NUM) CONTEXT_INV_ORG,
140: NVL(ovd.CONTEXT_ASSET_BOOK, Okl_Api.G_MISS_CHAR) CONTEXT_ASSET_BOOK,
141: ove.FROM_DATE FROM_DATE,
142: NVL(ove.TO_DATE, Okl_Api.G_MISS_DATE) TO_DATE
143: FROM Okl_Opv_Rules_V ovd,
144: Okl_Opt_Rules_V orl,
145: Okl_Opt_Values_V ove
146: WHERE ovd.ID = p_ovd_id
147: AND orl.ID = ovd.ORL_ID