DBA Data[Home] [Help]

APPS.QP_ATTR_GRP_PVT dependencies on QP_PRC_CONTEXTS_B

Line 2599: from qp_prc_contexts_b a, qp_segments_b b

2595: FOR i in 1..context_t.count
2596: LOOP
2597: select b.segment_id
2598: into segment_id_t(i)
2599: from qp_prc_contexts_b a, qp_segments_b b
2600: where b.prc_context_id = a.prc_context_id
2601: and a.PRC_CONTEXT_CODE = context_t(i)
2602: and b.SEGMENT_MAPPING_COLUMN = attribute_t(i);
2603: END LOOP;

Line 2705: from qp_prc_contexts_b a, qp_segments_b b

2701: FOR i in 1..context_t.count
2702: LOOP
2703: select b.segment_id
2704: into segment_id_t(i)
2705: from qp_prc_contexts_b a, qp_segments_b b
2706: where b.prc_context_id = a.prc_context_id
2707: and a.PRC_CONTEXT_CODE = context_t(i)
2708: and b.SEGMENT_MAPPING_COLUMN = attribute_t(i);
2709: END LOOP;

Line 2750: from qp_prc_contexts_b a, qp_segments_b b

2746: FOR i in 1..context_t.count
2747: LOOP
2748: select b.segment_id
2749: into segment_id_t(i)
2750: from qp_prc_contexts_b a, qp_segments_b b
2751: where b.prc_context_id = a.prc_context_id
2752: and a.PRC_CONTEXT_CODE = context_t(i)
2753: and b.SEGMENT_MAPPING_COLUMN = attribute_t(i);
2754: END LOOP;