APPS.OKS_BILL_UTIL_PUB dependencies on OKS_BILL_TXN_LINES

Line 4374: FROM oks_bill_txn_lines

4370: attribute_category,attribute1,attribute2,attribute3,attribute4,
4371: attribute5,attribute6,attribute7,attribute8,attribute9,
4372: attribute10,attribute11,attribute12,attribute13,attribute14,attribute15,
4373: trx_amount,cycle_refrence
4374: FROM oks_bill_txn_lines
4375: WHERE bcl_id = p_bcl_id
4376: AND bsl_id = p_old_bsl_id;
4377:
4378:

Line 4641: UPDATE oks_bill_txn_lines

4637: END IF;
4638:
4639: IF l_btl_rec.split_flag IS NULL THEN
4640:
4641: UPDATE oks_bill_txn_lines
4642: SET trx_line_tax_amount = l_btl_rec.trx_line_tax_amount - l_btlv_tbl_in(1).trx_line_tax_amount,
4643: trx_amount = NVL(l_btl_rec.trx_amount,0) - NVL(l_btlv_tbl_in(1).trx_amount,0),
4644: trx_line_amount = NVL(l_btl_rec.trx_amount,0) - NVL(l_btlv_tbl_in(1).trx_amount,0),
4645: split_flag = 'P'

Line 4648: UPDATE oks_bill_txn_lines

4644: trx_line_amount = NVL(l_btl_rec.trx_amount,0) - NVL(l_btlv_tbl_in(1).trx_amount,0),
4645: split_flag = 'P'
4646: WHERE id = l_btl_rec.id;
4647: ELSE
4648: UPDATE oks_bill_txn_lines
4649: SET trx_line_tax_amount = l_btl_rec.trx_line_tax_amount - l_btlv_tbl_in(1).trx_line_tax_amount,
4650: trx_amount = NVL(l_btl_rec.trx_amount,0) - NVL(l_btlv_tbl_in(1).trx_amount,0),
4651: trx_line_amount = NVL(l_btl_rec.trx_amount,0) - NVL(l_btlv_tbl_in(1).trx_amount,0)
4652: WHERE id = l_btl_rec.id;