APPS.OKS_BILL_REC_PUB dependencies on OKS_PRICE_BREAKS

Line 9898: FROM OKS_PRICE_BREAKS pb,

9894: X_RETURN_STATUS OUT NOCOPY VARCHAR2 ) is
9895: CURSOR price_break_csr (P_BSL_ID IN NUMBER) is
9896: SELECT pb.id, pb.amount,pb.unit_price , pb.quantity ,
9897: hdr.currency_code
9898: FROM OKS_PRICE_BREAKS pb,
9899: OKC_K_HEADERS_B hdr
9900: WHERE pb.bsl_id = P_BSL_ID
9901: AND pb.chr_id = hdr.id
9902: ORDER BY pb.quantity_from;

Line 9920: UPDATE oks_price_breaks

9916: l_running_total := l_running_total + l_amount;
9917: l_id := cur.id;
9918: l_currency_code := cur.currency_code;
9919:
9920: UPDATE oks_price_breaks
9921: SET amount = l_amount,
9922: unit_price = l_unit_price
9923: WHERE id = cur.id;
9924: END LOOP;

Line 9927: UPDATE oks_price_breaks

9923: WHERE id = cur.id;
9924: END LOOP;
9925:
9926: IF ( l_running_total <> P_TOT_AMOUNT) THEN
9927: UPDATE oks_price_breaks
9928: SET amount = OKS_EXTWAR_UTIL_PVT.round_currency_amt(amount + (P_TOT_AMOUNT - l_running_total),l_currency_code),
9929: unit_price = round((amount + (P_TOT_AMOUNT - l_running_total)) / quantity,29)
9930: WHERE id = l_id;
9931: END IF;