APPS.OKS_BILL_REC_PUB dependencies on OKS_PRICE_BREAKS

Line 9808: FROM OKS_PRICE_BREAKS pb,

9804: X_RETURN_STATUS OUT NOCOPY VARCHAR2 ) is
9805: CURSOR price_break_csr (P_BSL_ID IN NUMBER) is
9806: SELECT pb.id, pb.amount,pb.unit_price , pb.quantity ,
9807: hdr.currency_code
9808: FROM OKS_PRICE_BREAKS pb,
9809: OKC_K_HEADERS_B hdr
9810: WHERE pb.bsl_id = P_BSL_ID
9811: AND pb.chr_id = hdr.id
9812: ORDER BY pb.quantity_from;

Line 9830: UPDATE oks_price_breaks

9826: l_running_total := l_running_total + l_amount;
9827: l_id := cur.id;
9828: l_currency_code := cur.currency_code;
9829:
9830: UPDATE oks_price_breaks
9831: SET amount = l_amount,
9832: unit_price = l_unit_price
9833: WHERE id = cur.id;
9834: END LOOP;

Line 9837: UPDATE oks_price_breaks

9833: WHERE id = cur.id;
9834: END LOOP;
9835:
9836: IF ( l_running_total <> P_TOT_AMOUNT) THEN
9837: UPDATE oks_price_breaks
9838: SET amount = OKS_EXTWAR_UTIL_PVT.round_currency_amt(amount + (P_TOT_AMOUNT - l_running_total),l_currency_code),
9839: unit_price = round((amount + (P_TOT_AMOUNT - l_running_total)) / quantity,29)
9840: WHERE id = l_id;
9841: END IF;