APPS.QPR_DEAL_ETL dependencies on QPR_PN_PR_TYPES

Line 218: from qpr_pn_pr_types

214:
215: cursor c_price_types is
216: select pn_pr_type_id, price_type_name, derived_from_type,
217: erosion_type, column_name
218: from qpr_pn_pr_types
219: order by sequence_no;
220:
221: cursor c_hdr_pric is
222: select pr1.pn_pr_type_id, sum(pr1.amount) amount,

Line 226: from qpr_pn_prices pr1, qpr_pn_prices pr2, qpr_pn_lines l, qpr_pn_pr_types prt

222: select pr1.pn_pr_type_id, sum(pr1.amount) amount,
223: decode(sum(pr2.amount),0,0, 100 * sum(pr1.amount)/sum(pr2.amount))
224: percent_price,
225: decode(sum(l.ordered_qty), 0, 0, sum(pr1.amount)* count(l.pn_line_id)/sum(l.ordered_qty)) unit_price
226: from qpr_pn_prices pr1, qpr_pn_prices pr2, qpr_pn_lines l, qpr_pn_pr_types prt
227: where pr1.response_header_id = p_response_hdr_id
228: and pr1.response_header_id = l.response_header_id
229: and pr1.pn_line_id = l.pn_line_id
230: and pr1.response_header_id = pr2.response_header_id

Line 379: from qpr_pn_prices p, qpr_pn_pr_types t

375: l_curr_conv number;
376:
377: cursor c_pn_prices(p_policy_meas_type varchar2) is
378: select p.pn_price_id
379: from qpr_pn_prices p, qpr_pn_pr_types t
380: where p.pn_pr_type_id = t.pn_pr_type_id
381: and p.pn_line_id = p_pn_line_id
382: and t.erosion_type = p_policy_meas_type
383: and rownum < 2;

Line 567: from qpr_pn_prices p, qpr_pn_pr_types t

563: l_cost number := 0;
564:
565: cursor c_pric is
566: select nvl(p.unit_price, 0) price, t.price_type_name
567: from qpr_pn_prices p, qpr_pn_pr_types t
568: where p.pn_line_id = p_pn_line_id
569: and p.pn_pr_type_id = t.pn_pr_type_id;
570:
571: begin

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 660: from qpr_pn_lines l, qpr_pn_prices pr, qpr_pn_pr_types prt,

656: l_PROPOSED_PRICE,
657: l_recommended_price,
658: l_regression_intercept,
659: l_aw_uom, l_aw_curr
660: from qpr_pn_lines l, qpr_pn_prices pr, qpr_pn_pr_types prt,
661: qpr_price_plans_b pp
662: where l.parent_pn_line_id= c_mdl_lines_rec.source_ref_line_id
663: and l.response_header_id = p_response_id
664: and l.response_header_id = pr.response_header_id

Line 1270: from qpr_pn_lines l, qpr_pn_prices pr, qpr_pn_pr_types prt

1266: begin
1267: select round(sum(nvl(l.line_pricing_score,0)*nvl(pr.amount,0))/
1268: sum(nvl(pr.amount,0)), 2)
1269: into l_total_score
1270: from qpr_pn_lines l, qpr_pn_prices pr, qpr_pn_pr_types prt
1271: where l.response_header_id = l_response_id
1272: and pr.response_header_id= l.response_header_id
1273: and pr.pn_line_id = l.pn_line_id
1274: and pr.pn_pr_type_id = prt.pn_pr_type_id

Line 1506: select * from qpr_pn_pr_types order by sequence_no;

1502: p_src_id in number,
1503: p_price_type_name in varchar2)
1504: return number is
1505: cursor c_pr_type is
1506: select * from qpr_pn_pr_types order by sequence_no;
1507:
1508: cursor c_adjs(p_erosion_type varchar2) is
1509: select nvl(sum(erosion_per_unit),0) unit_erosion
1510: from qpr_pn_int_pr_adjs

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';