DBA Data[Home] [Help]

APPS.QP_PS_ATTR_GRP_PVT dependencies on QP_SEGMENTS_B

Line 5111: from qp_prc_contexts_b a, qp_segments_b b

5107: FOR i in 1..context_t.count
5108: LOOP
5109: select b.segment_id
5110: into segment_id_t(i)
5111: from qp_prc_contexts_b a, qp_segments_b b
5112: where b.prc_context_id = a.prc_context_id
5113: and a.PRC_CONTEXT_CODE = context_t(i)
5114: and b.SEGMENT_MAPPING_COLUMN = attribute_t(i);
5115: END LOOP;

Line 5237: from qp_prc_contexts_b a, qp_segments_b b

5233: FOR i in 1..context_t.count
5234: LOOP
5235: select b.segment_id
5236: into segment_id_t(i)
5237: from qp_prc_contexts_b a, qp_segments_b b
5238: where b.prc_context_id = a.prc_context_id
5239: and a.PRC_CONTEXT_CODE = context_t(i)
5240: and b.SEGMENT_MAPPING_COLUMN = attribute_t(i);
5241: END LOOP;

Line 5290: from qp_prc_contexts_b a, qp_segments_b b

5286: FOR i in 1..context_t.count
5287: LOOP
5288: select b.segment_id
5289: into segment_id_t(i)
5290: from qp_prc_contexts_b a, qp_segments_b b
5291: where b.prc_context_id = a.prc_context_id
5292: and a.PRC_CONTEXT_CODE = context_t(i)
5293: and b.SEGMENT_MAPPING_COLUMN = attribute_t(i);
5294: END LOOP;