APPS.QPR_DEAL_PVT dependencies on QPR_SCOPES

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

123: select a.level_id level_id, a.operator operator,
124: a.scope_value scope_value, b.level_ppa_code level_ppa_code,
125: b.level_seq_num level_seq_no, c.hierarchy_ppa_code hierarchy_code,
126: c.dim_code dim_code
127: from qpr_scopes a, qpr_hier_levels b, qpr_hierarchies_v c
128: where b.price_plan_id= qpr_sr_util.g_datamart_tmpl_id
129: and b.hierarchy_level_id=a.level_id
130: and b.hierarchy_id = c.hierarchy_id
131: and a.scope_id= p_scope_id

Line 291: from qpr_price_plans_vl p, qpr_scopes s

287: l_datamart number;
288:
289: cursor c_datamart is
290: select distinct p.price_plan_id, s.scope_id , p.name, p.start_date
291: from qpr_price_plans_vl p, qpr_scopes s
292: where p.aw_created_flag = 'Y' and p.aw_status_code = 'PROCESS'
293: --and p.use_for_deal_flag = 'Y'
294: and p.aw_type_code = 'DATAMART'
295: and p.instance_id = p_instance_id