APPS.QPR_POLICY_EVAL dependencies on QPR_PR_SEGMENTS_B

Line 46: from qpr_pr_segments_b

42: if i_psg_id = qpr_sr_util.get_null_pk then
43: l_policy_id := fnd_profile.value('QPR_DEFAULT_POLICY');
44: else
45: select DEFAULT_POLICY_ID into l_policy_id
46: from qpr_pr_segments_b
47: where PR_SEGMENT_ID = i_psg_id;
48: end if;
49: else
50: l_policy_id := i_policy_id;

Line 106: from qpr_pr_segments_b

102: select p.pr_segment_id, p.policy_importance_code
103: into o_pr_segment_id, o_pol_importance_code
104: from
105: (select default_policy_id, pr_segment_id, policy_importance_code
106: from qpr_pr_segments_b
107: where (pr_segment_id in (
108: select a.parent_id
109: from qpr_scopes a,
110: (select s.parent_id, s.dim_code

Line 113: qpr_pr_segments_b psg

109: from qpr_scopes a,
110: (select s.parent_id, s.dim_code
111: from qpr_dimension_values dv,qpr_scopes s,
112: qpr_hierarchies h, qpr_hier_levels l,
113: qpr_pr_segments_b psg
114: where s.parent_entity_type = 'PRICINGSEGMENT'
115: and s.parent_id = psg.pr_segment_id
116: and psg.instance_id = i_instance_id
117: and s.DIM_CODE = dv.DIM_CODE

Line 322: l_importance_rank qpr_pr_segments_b.policy_importance_code%TYPE;

318:
319: l_policy_id number;
320: l_limit_value_type_code varchar2(30);
321: l_ref_limit_value number;
322: l_importance_rank qpr_pr_segments_b.policy_importance_code%TYPE;
323:
324:
325: procedure insert_pol_measures is
326: begin