DBA Data[Home] [Help]

APPS.QPR_MAINTAIN_AW dependencies on QPR_DIMENSION_VALUES

Line 170: select level1_value from qpr_dimension_values

166: p_level_seq_num number,
167: p_scope_value varchar2) is
168:
169: cursor c_level_values is
170: select level1_value from qpr_dimension_values
171: where dim_code = p_dim_code
172: and hierarchy_code = p_hierarchy_code
173: and instance_id = g_instance
174: and (decode(p_level_seq_num, 1, level1_value,