APPS.OKS_BILL_UTIL_PUB dependencies on OKS_BILL_TXN_LINES

Line 4868: FROM oks_bill_txn_lines

4864: attribute_category,attribute1,attribute2,attribute3,attribute4,
4865: attribute5,attribute6,attribute7,attribute8,attribute9,
4866: attribute10,attribute11,attribute12,attribute13,attribute14,attribute15,
4867: trx_amount,cycle_refrence
4868: FROM oks_bill_txn_lines
4869: WHERE bcl_id = p_bcl_id
4870: AND bsl_id = p_old_bsl_id;
4871:
4872:

Line 5135: UPDATE oks_bill_txn_lines

5131: END IF;
5132:
5133: IF l_btl_rec.split_flag IS NULL THEN
5134:
5135: UPDATE oks_bill_txn_lines
5136: SET trx_line_tax_amount = l_btl_rec.trx_line_tax_amount - l_btlv_tbl_in(1).trx_line_tax_amount,
5137: trx_amount = NVL(l_btl_rec.trx_amount,0) - NVL(l_btlv_tbl_in(1).trx_amount,0),
5138: trx_line_amount = NVL(l_btl_rec.trx_amount,0) - NVL(l_btlv_tbl_in(1).trx_amount,0),
5139: split_flag = 'P'

Line 5142: UPDATE oks_bill_txn_lines

5138: trx_line_amount = NVL(l_btl_rec.trx_amount,0) - NVL(l_btlv_tbl_in(1).trx_amount,0),
5139: split_flag = 'P'
5140: WHERE id = l_btl_rec.id;
5141: ELSE
5142: UPDATE oks_bill_txn_lines
5143: SET trx_line_tax_amount = l_btl_rec.trx_line_tax_amount - l_btlv_tbl_in(1).trx_line_tax_amount,
5144: trx_amount = NVL(l_btl_rec.trx_amount,0) - NVL(l_btlv_tbl_in(1).trx_amount,0),
5145: trx_line_amount = NVL(l_btl_rec.trx_amount,0) - NVL(l_btlv_tbl_in(1).trx_amount,0)
5146: WHERE id = l_btl_rec.id;