APPS.OKL_SETUPOVERULES_PVT dependencies on OKL_OPT_RULES_V

Line 89: p_orl_id IN Okl_Opt_Rules_V.id%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,
93: Okl_Opt_Rules_V orl,

Line 93: Okl_Opt_Rules_V orl,

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
97: AND ((orl.LRG_LSE_ID IS NOT NULL

Line 352: FROM okl_opt_rules_v

348: ,x_return_status OUT NOCOPY VARCHAR2)
349: IS
350: CURSOR okl_orlv_pk_csr (p_id IN NUMBER) IS
351: SELECT '1'
352: FROM okl_opt_rules_v
353: WHERE okl_opt_rules_v.id = p_id;
354:
355: l_orl_status VARCHAR2(1);
356: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line 353: WHERE okl_opt_rules_v.id = p_id;

349: IS
350: CURSOR okl_orlv_pk_csr (p_id IN NUMBER) IS
351: SELECT '1'
352: FROM okl_opt_rules_v
353: WHERE okl_opt_rules_v.id = p_id;
354:
355: l_orl_status VARCHAR2(1);
356: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
357: l_row_notfound BOOLEAN := TRUE;