APPS.QPR_DEAL_ETL dependencies on QPR_PN_POLICIES

Line 389: from qpr_pn_policies p , qpr_pn_prices pr, qpr_policy_lines pl

385: cursor c_pol_det is
386: select p.policy_line_id, p.policy_id, pl.policy_type_code, pl.policy_measure_type_code,
387: pl.limit_value_type_code,
388: pl.ref_limit_value, null, null
389: from qpr_pn_policies p , qpr_pn_prices pr, qpr_policy_lines pl
390: where p.pn_price_id = pr.pn_price_id
391: and pr.pn_line_id = p_pol_ref_line_id
392: and p.policy_id = pl.policy_id
393: and p.policy_line_id = pl.policy_line_id;

Line 458: insert into qpr_pn_policies(PN_POLICY_ID,

454: end if;
455:
456: if rec_pn_pol_ins.policy_id.count > 0 then
457: forall i in rec_pn_pol_ins.POLICY_ID.first..rec_pn_pol_ins.POLICY_ID.last
458: insert into qpr_pn_policies(PN_POLICY_ID,
459: PN_PRICE_ID,
460: POLICY_ID,
461: POLICY_LINE_ID,
462: POLICY_PRICE,

Line 469: values(qpr_pn_policies_s.nextval,

465: CREATED_BY,
466: LAST_UPDATE_DATE,
467: LAST_UPDATED_BY,
468: LAST_UPDATE_LOGIN)
469: values(qpr_pn_policies_s.nextval,
470: rec_pn_pol_ins.pn_price_id(i),
471: rec_pn_pol_ins.policy_id(i),
472: rec_pn_pol_ins.policy_line_id(i),
473: rec_pn_pol_ins.policy_price(i),

Line 579: from qpr_pn_policies p, qpr_pn_prices pric, qpr_pn_pr_types t

575: where p.pn_line_id = p_pn_line_id
576: and p.erosion_type = 'COST';
577:
578: select nvl(min(p.policy_price) , 0) into l_floor_mrg
579: from qpr_pn_policies p, qpr_pn_prices pric, qpr_pn_pr_types t
580: where pric.pn_line_id = p_pn_line_id
581: and p.pn_price_id = pric.pn_price_id
582: and pric.pn_pr_type_id = t.pn_pr_type_id
583: and t.price_type_name = 'POCMARGIN';

Line 2037: from qpr_pn_policies op,

2033: op.POLICY_PRICE,
2034: op.POLICY_AMOUNT,
2035: op.policy_line_id,
2036: n.pn_price_id
2037: from qpr_pn_policies op,
2038: qpr_pn_prices o, qpr_pn_lines ol,
2039: qpr_pn_lines nl, qpr_pn_prices n
2040: where op.pn_price_id = o.pn_price_id
2041: and o.response_header_id = p_response_hdr_id

Line 2323: insert into qpr_pn_policies(PN_POLICY_ID,

2319: t_unit_val, t_amnt, t_pol_line_id, t_pr_typ_id
2320: limit l_rows;
2321: exit when t_pr_typ_id.count = 0;
2322: forall i in t_pr_typ_id.first..t_pr_typ_id.last
2323: insert into qpr_pn_policies(PN_POLICY_ID,
2324: PN_PRICE_ID,
2325: POLICY_ID,
2326: POLICY_PRICE,
2327: POLICY_AMOUNT,

Line 2334: values(qpr_pn_policies_s.nextval,

2330: CREATED_BY,
2331: LAST_UPDATE_DATE,
2332: LAST_UPDATED_BY,
2333: LAST_UPDATE_LOGIN)
2334: values(qpr_pn_policies_s.nextval,
2335: t_pr_typ_id(i),
2336: t_pol_id(i),
2337: t_unit_val(i),
2338: t_amnt(i),

Line 2436: delete qpr_pn_policies where pn_policy_id in(

2432: end if;
2433:
2434: log_debug('Volume band: '|| l_vol_band);
2435:
2436: delete qpr_pn_policies where pn_policy_id in(
2437: select pol.pn_policy_id
2438: from qpr_pn_policies pol,qpr_pn_prices pr
2439: where pr.pn_price_id = pol.pn_price_id
2440: and pr.response_header_id = i_response_header_id

Line 2438: from qpr_pn_policies pol,qpr_pn_prices pr

2434: log_debug('Volume band: '|| l_vol_band);
2435:
2436: delete qpr_pn_policies where pn_policy_id in(
2437: select pol.pn_policy_id
2438: from qpr_pn_policies pol,qpr_pn_prices pr
2439: where pr.pn_price_id = pol.pn_price_id
2440: and pr.response_header_id = i_response_header_id
2441: and pr.pn_line_id = i_line_id);
2442:

Line 2449: from qpr_pn_policies p, qpr_pn_prices pric, qpr_pn_pr_types t

2445:
2446: end if;
2447:
2448: select nvl(min(p.policy_price) , 0) into l_floor_margin
2449: from qpr_pn_policies p, qpr_pn_prices pric, qpr_pn_pr_types t
2450: where pric.pn_line_id = i_line_id
2451: and p.pn_price_id = pric.pn_price_id
2452: and pric.pn_pr_type_id = t.pn_pr_type_id
2453: and t.price_type_name = 'POCMARGIN';