DBA Data[Home] [Help]

APPS.QP_UTIL dependencies on QP_SEGMENTS_V

Line 2446: FROM qp_segments_v a, qp_prc_contexts_b b

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

Line 2457: FROM qp_segments_v a, qp_prc_contexts_b b

2453:
2454: CURSOR qual_attribute_name_cur(a_context_code VARCHAR2, a_segment_name VARCHAR2)
2455: IS
2456: SELECT a.segment_mapping_column
2457: FROM qp_segments_v a, qp_prc_contexts_b b
2458: WHERE b.prc_context_id = a.prc_context_id
2459: AND b.prc_context_code = a_context_code
2460: AND a.segment_code = a_segment_name
2461: AND a.segment_mapping_column like 'QUALIFIER%';--deliberately matching a_segment_name