APPS.QPR_POLICY_EVAL dependencies on QPR_POLICY_LINES

Line 20: l_prev_pol_type qpr_policy_lines.POLICY_TYPE_CODE%type := '';

16: i_policy_type in varchar2 default null,
17: o_policy_det out nocopy policy_det_rec_type) is
18: l_policy_id number;
19: l_ctr number := 0;
20: l_prev_pol_type qpr_policy_lines.POLICY_TYPE_CODE%type := '';
21: l_prev_pol_meas qpr_policy_lines.POLICY_MEASURE_TYPE_CODE%type := '';
22:
23: cursor c_pol(p_policy_id number) is
24: select policy_line_id, policy_id,

Line 21: l_prev_pol_meas qpr_policy_lines.POLICY_MEASURE_TYPE_CODE%type := '';

17: o_policy_det out nocopy policy_det_rec_type) is
18: l_policy_id number;
19: l_ctr number := 0;
20: l_prev_pol_type qpr_policy_lines.POLICY_TYPE_CODE%type := '';
21: l_prev_pol_meas qpr_policy_lines.POLICY_MEASURE_TYPE_CODE%type := '';
22:
23: cursor c_pol(p_policy_id number) is
24: select policy_line_id, policy_id,
25: policy_type_code, policy_measure_type_code,

Line 28: from qpr_policy_lines

24: select policy_line_id, policy_id,
25: policy_type_code, policy_measure_type_code,
26: limit_value_type_code, ref_limit_value,
27: effective_date_from, effective_date_to
28: from qpr_policy_lines
29: where policy_id = p_policy_id
30: and policy_measure_type_code = nvl(i_policy_meas_type,
31: policy_measure_type_code)
32: and policy_type_code = nvl(i_policy_type, policy_type_code)

Line 182: from qpr_policy_lines

178: select policy_type_code,policy_measure_type_code,
179: limit_value_type_code,ref_limit_value,
180: effective_date_from,effective_date_to,
181: vlb_level_value,vlb_level_value_desc
182: from qpr_policy_lines
183: where policy_id = p_policy_id;
184:
185: begin
186:

Line 239: insert into qpr_policy_lines(policy_line_id,

235: fnd_global.login_id);
236: end loop;
237:
238: for rec_line in c_pol_line loop
239: insert into qpr_policy_lines(policy_line_id,
240: policy_id,
241: policy_type_code,
242: policy_measure_type_code,
243: limit_value_type_code,

Line 254: values(qpr_policy_lines_s.nextval,

250: created_by,
251: last_update_date,
252: last_updated_by,
253: last_update_login)
254: values(qpr_policy_lines_s.nextval,
255: l_new_pol_id,
256: rec_line.policy_type_code,
257: rec_line.policy_measure_type_code,
258: rec_line.limit_value_type_code,