DBA Data[Home] [Help]

APPS.QPR_REGRESSION_ANALYSIS dependencies on QPR_SCOPES

Line 102: qpr_scopes sc, qpr_dimensions dim,

98: sc.dim_code dim_code, hier.hierarchy_ppa_code hier_code,
99: hl.level_seq_num lvl_num, sc.scope_value lvl_value,
100: sc.operator op_sign
101: from
102: qpr_scopes sc, qpr_dimensions dim,
103: qpr_hierarchies hier, qpr_hier_levels hl
104: where dim.price_plan_id = 1
105: and hier.price_plan_id = 1
106: and hl.price_plan_id = 1

Line 258: from qpr_scopes

254:
255:
256: begin
257: select 1 into l_scope_exists
258: from qpr_scopes
259: where parent_entity_type = 'DATAMART'
260: and parent_id = p_price_plan_id
261: and rownum < 2;
262: exception