APPS.QPR_MAINTAIN_AW dependencies on QPR_HIERARCHIES_V

Line 246: from qpr_scopes a, qpr_hier_levels b, qpr_hierarchies_v c

242: select a.level_id level_id, a.operator operator,
243: a.scope_value scope_value, b.level_ppa_code level_ppa_code,
244: b.level_seq_num level_seq_num, c.hierarchy_ppa_code hierarchy_ppa_code,
245: c.dim_code dim_code
246: from qpr_scopes a, qpr_hier_levels b, qpr_hierarchies_v c
247: where b.price_plan_id= qpr_sr_util.g_datamart_tmpl_id
248: and b.hierarchy_level_id=a.level_id
249: and b.hierarchy_id = c.hierarchy_id
250: and a.parent_entity_type = 'DATAMART'

Line 299: from qpr_hierarchies_v

295:
296: log_debug('Price Plan read.');
297: begin
298: select calendar_code into g_calendar_code
299: from qpr_hierarchies_v
300: where price_plan_id=p_price_plan_id
301: --and dim_code = 'TIM'
302: and rownum<2
303: and hierarchy_ppa_code='FISCAL';