APPS.OKS_ARFEEDER_PUB dependencies on OKS_PRICE_BREAKS

Line 1945: FROM OKS_PRICE_BREAKS

1941: Cursor Price_breaks_cur(p_id IN NUMBER) IS
1942: SELECT quantity,
1943: unit_price,
1944: amount
1945: FROM OKS_PRICE_BREAKS
1946: WHERE bsl_id = p_id
1947: ORDER BY quantity_from;
1948:
1949: -- Added the sales_order in where condition as part of

Line 2605: FROM oks_price_breaks

2601:
2602:
2603: Cursor chk_price_break_cur(p_id IN NUMBER) IS
2604: SELECT count(1)
2605: FROM oks_price_breaks
2606: WHERE bsl_id = p_id;
2607:
2608: Cursor cur_okc_k_item_qty(p_id IN NUMBER) IS
2609: SELECT Number_of_items,

Line 4988: FROM OKS_PRICE_BREAKS pb,

4984: SELECT pb.quantity_from,
4985: pb.unit_price,
4986: pb.amount,
4987: btl.bsl_id
4988: FROM OKS_PRICE_BREAKS pb,
4989: oks_bill_txn_lines btl
4990: WHERE pb.bsl_id = btl.bsl_id
4991: AND btl.bill_instance_number = p_bill_inst_no
4992: AND pb.amount > 0

Line 4999: FROM OKS_PRICE_BREAKS

4995: Cursor l_inv_csr(p_bsl_id IN NUMBER) IS
4996: SELECT quantity,
4997: unit_price,
4998: amount, quantity_from
4999: FROM OKS_PRICE_BREAKS
5000: WHERE bsl_id = p_bsl_id
5001: ORDER BY abs(amount);
5002:
5003: l_pb_inv_rec l_pb_inv_csr%ROWTYPE;