APPS.CS_KB_SET_RECS_PKG dependencies on CS_KB_SECURE_SOLUTIONS_VIEW

Line 64: from cs_kb_set_recs sr, cs_kb_secure_solutions_view sv

60: -- the recommended solutions list the user cannot access.
61: select sr1.set_rec_id, sr1.set_order into l_set_rec_id_prev, l_prev_order
62: from cs_kb_set_recs sr1 where sr1.set_order =
63: (select max(sr.set_order)
64: from cs_kb_set_recs sr, cs_kb_secure_solutions_view sv
65: where sr.set_number = sv.set_number
66: and sv.viewable_version_flag = 'Y'
67: and sv.status = 'PUB'
68: and sr.set_order < l_order );

Line 136: from cs_kb_set_recs sr, cs_kb_secure_solutions_view sv

132: -- the recommended solutions list the user cannot access.
133: select sr1.set_rec_id, sr1.set_order into l_set_rec_id_next, l_next_order
134: from cs_kb_set_recs sr1 where sr1.set_order =
135: (select min(sr.set_order)
136: from cs_kb_set_recs sr, cs_kb_secure_solutions_view sv
137: where sr.set_number = sv.set_number
138: and sv.viewable_version_flag = 'Y'
139: and sv.status = 'PUB'
140: and sr.set_order > l_order );

Line 242: from cs_kb_secure_solutions_view

238: -- Find the solution id for latest viewable solution version,
239: -- given the solution number.
240: begin
241: select distinct set_id into l_set_id
242: from cs_kb_secure_solutions_view
243: where set_number = p_set_number
244: and viewable_version_flag = 'Y'
245: and status = 'PUB';
246: exception