APPS.OKS_ARFEEDER_PUB dependencies on OKS_PRICE_BREAKS

Line 1931: FROM OKS_PRICE_BREAKS

1927: Cursor Price_breaks_cur(p_id IN NUMBER) IS
1928: SELECT quantity,
1929: unit_price,
1930: amount
1931: FROM OKS_PRICE_BREAKS
1932: WHERE bsl_id = p_id
1933: ORDER BY quantity_from;
1934:
1935: -- Added the sales_order in where condition as part of

Line 2586: FROM oks_price_breaks

2582:
2583:
2584: Cursor chk_price_break_cur(p_id IN NUMBER) IS
2585: SELECT count(1)
2586: FROM oks_price_breaks
2587: WHERE bsl_id = p_id;
2588:
2589: Cursor cur_okc_k_item_qty(p_id IN NUMBER) IS
2590: SELECT Number_of_items,

Line 4834: FROM OKS_PRICE_BREAKS pb,

4830: SELECT pb.quantity_from,
4831: pb.unit_price,
4832: pb.amount,
4833: btl.bsl_id
4834: FROM OKS_PRICE_BREAKS pb,
4835: oks_bill_txn_lines btl
4836: WHERE pb.bsl_id = btl.bsl_id
4837: AND btl.bill_instance_number = p_bill_inst_no
4838: AND pb.amount > 0

Line 4845: FROM OKS_PRICE_BREAKS

4841: Cursor l_inv_csr(p_bsl_id IN NUMBER) IS
4842: SELECT quantity,
4843: unit_price,
4844: amount, quantity_from
4845: FROM OKS_PRICE_BREAKS
4846: WHERE bsl_id = p_bsl_id
4847: ORDER BY abs(amount);
4848:
4849: l_pb_inv_rec l_pb_inv_csr%ROWTYPE;