APPS.OKL_SETUPOPTRULES_PVT dependencies on OKL_OPTIONS_V

Line 87: CURSOR okl_orl_pon_fk_csr (p_opt_id IN Okl_Options_V.ID%TYPE

83: p_orlv_rec IN orlv_rec_type,
84: x_return_status OUT NOCOPY VARCHAR2,
85: x_valid OUT NOCOPY BOOLEAN
86: ) IS
87: CURSOR okl_orl_pon_fk_csr (p_opt_id IN Okl_Options_V.ID%TYPE
88: ) IS
89: SELECT '1'
90: FROM Okl_Pdt_Opts_V pon
91: WHERE pon.OPT_ID = p_opt_id;

Line 99: CURSOR okl_orl_opt_fk_csr (p_opt_id IN Okl_Options_V.ID%TYPE,

95: SELECT '1'
96: FROM Okl_Opv_Rules_V ovd
97: WHERE ovd.ORL_ID = p_orl_id;
98:
99: CURSOR okl_orl_opt_fk_csr (p_opt_id IN Okl_Options_V.ID%TYPE,
100: p_date IN Okl_Options_V.TO_DATE%TYPE
101: ) IS
102: SELECT '1'
103: FROM Okl_Options_V opt

Line 100: p_date IN Okl_Options_V.TO_DATE%TYPE

96: FROM Okl_Opv_Rules_V ovd
97: WHERE ovd.ORL_ID = p_orl_id;
98:
99: CURSOR okl_orl_opt_fk_csr (p_opt_id IN Okl_Options_V.ID%TYPE,
100: p_date IN Okl_Options_V.TO_DATE%TYPE
101: ) IS
102: SELECT '1'
103: FROM Okl_Options_V opt
104: WHERE opt.ID = p_opt_id

Line 103: FROM Okl_Options_V opt

99: CURSOR okl_orl_opt_fk_csr (p_opt_id IN Okl_Options_V.ID%TYPE,
100: p_date IN Okl_Options_V.TO_DATE%TYPE
101: ) IS
102: SELECT '1'
103: FROM Okl_Options_V opt
104: WHERE opt.ID = p_opt_id
105: AND NVL(opt.TO_DATE, p_date) < p_date;
106:
107: CURSOR okl_orl_lsr_fk_csr (p_opt_id IN Okl_Opt_Rules_V.opt_id%TYPE,

Line 116: Okl_Options_V opt

112: p_rgr_rdf_code IN Okl_Opt_Rules_V.rgr_rdf_code%TYPE
113: ) IS
114: SELECT '1'
115: FROM Okl_Lse_Scs_Rules_V lsr,
116: Okl_Options_V opt
117: WHERE opt.ID = p_opt_id
118: AND ((p_lrg_lse_id <> Okl_Api.G_MISS_NUM
119: AND lsr.LSE_ID = p_lrg_lse_id
120: AND lsr.SRD_ID = p_lrg_srd_id)