APPS.QPR_DEAL_ETL dependencies on QPR_PN_INT_PR_ADJS_S

Line 1380: update qpr_pn_int_pr_adjs set erosion_per_unit = p_er_det_rec.unit_cost,

1376: and pr.source_id = l.source_id
1377: and erosion_type = 'COST'
1378: and rownum < 2;
1379:
1380: update qpr_pn_int_pr_adjs set erosion_per_unit = p_er_det_rec.unit_cost,
1381: erosion_amount = p_er_det_rec.unit_cost * l_ord_qty
1382: where pn_int_pr_adj_id = l_adj_id;
1383:
1384: log_debug('updated cost: unit cost' || p_er_det_rec.unit_cost);

Line 1420: values(qpr_pn_int_pr_adjs_s.nextval,

1416: CREATED_BY,
1417: LAST_UPDATE_DATE,
1418: LAST_UPDATED_BY,
1419: LAST_UPDATE_LOGIN)
1420: values(qpr_pn_int_pr_adjs_s.nextval,
1421: p_source_ref_hdr_id,
1422: p_source_ref_line_id,
1423: p_src_id,
1424: 'ONINVOICE',

Line 1467: values(qpr_pn_int_pr_adjs_s.nextval,

1463: CREATED_BY,
1464: LAST_UPDATE_DATE,
1465: LAST_UPDATED_BY,
1466: LAST_UPDATE_LOGIN)
1467: values(qpr_pn_int_pr_adjs_s.nextval,
1468: p_source_ref_hdr_id,
1469: p_source_ref_line_id,
1470: p_src_id,
1471: t_er_typ(i),