APPS.QP_JAVA_ENGINE_CACHE_PVT dependencies on QP_PATTERN_PHASES

Line 84: FROM qp_pattern_phases qpph, qp_patterns qpp

80: and qph.list_header_id = qpl.list_header_id);
81:
82: CURSOR pattern_ph_csr IS
83: SELECT count(*)
84: FROM qp_pattern_phases qpph, qp_patterns qpp
85: WHERE qpp.pattern_type = 'HP' and qpp.pattern_id = qpph.pattern_id;
86:
87: CURSOR okc_uom_csr IS
88: SELECT count(*)