DBA Data[Home] [Help]

APPS.QP_MASS_MAINTAIN_UTIL dependencies on QP_PRC_CONTEXTS_B

Line 172: from qp_segments_b seg, qp_prc_contexts_b cont, fnd_flex_value_sets vs

168:
169: -- select nvl(SEEDED_VALUESET_ID, USER_VALUESET_ID)
170: select nvl(USER_VALUESET_ID, SEEDED_VALUESET_ID)
171: into v_value_set_id
172: from qp_segments_b seg, qp_prc_contexts_b cont, fnd_flex_value_sets vs
173: where cont.PRC_CONTEXT_CODE = p_context_code
174: and seg.SEGMENT_CODE = p_segment_code
175: and nvl(user_valueset_id, seeded_valueset_id) = vs.flex_value_set_id
176: and cont.PRC_CONTEXT_ID = seg.PRC_CONTEXT_ID