DBA Data[Home] [Help]

APPS.PER_QP_INVOCATIONS dependencies on PER_QUICKPAINT_RESULT_TEXT

Line 190: from per_quickpaint_result_text

186: ,p_qp_invocation_id NUMBER) return VARCHAR2 is
187: --
188: cursor c is
189: select text
190: from per_quickpaint_result_text
191: where assignment_id = p_assignment_id
192: and qp_invocation_id = p_qp_invocation_id
193: order by line_number;
194: --

Line 239: from per_quickpaint_result_text t

235: , assignment_number
236: from per_quickpaint_assignments a
237: where assignment_id = p_assignment_id
238: and exists(select null
239: from per_quickpaint_result_text t
240: where t.assignment_id = p_assignment_id
241: and t.qp_invocation_id = p_qp_invocation_id);
242: --
243: begin