DBA Data[Home] [Help]

APPS.QP_UTIL dependencies on QP_SEGMENTS_V

Line 2433: FROM qp_segments_v a, qp_prc_contexts_b b

2429:
2430: CURSOR pricing_attribute_name_cur(a_context_code VARCHAR2, a_segment_name VARCHAR2)
2431: IS
2432: SELECT a.segment_mapping_column
2433: FROM qp_segments_v a, qp_prc_contexts_b b
2434: WHERE b.prc_context_id = a.prc_context_id
2435: AND b.prc_context_code = a_context_code
2436: AND a.segment_code = a_segment_name
2437: AND a.segment_mapping_column like 'PRICING%';--deliberately matching a_segment_name

Line 2444: FROM qp_segments_v a, qp_prc_contexts_b b

2440:
2441: CURSOR qual_attribute_name_cur(a_context_code VARCHAR2, a_segment_name VARCHAR2)
2442: IS
2443: SELECT a.segment_mapping_column
2444: FROM qp_segments_v a, qp_prc_contexts_b b
2445: WHERE b.prc_context_id = a.prc_context_id
2446: AND b.prc_context_code = a_context_code
2447: AND a.segment_code = a_segment_name
2448: AND a.segment_mapping_column like 'QUALIFIER%';--deliberately matching a_segment_name