DBA Data[Home] [Help]

APPS.OKS_BILL_UTIL_PUB dependencies on OKS_BILL_SUB_LINE_DTLS

Line 4857: FROM oks_bill_sub_line_dtls

4853: start_reading, end_reading,ccr_id,cgr_id,
4854: attribute_category,attribute1,attribute2,attribute3,attribute4 ,
4855: attribute5,attribute6,attribute7,attribute8,attribute9,
4856: attribute10,attribute11,attribute12,attribute13,attribute14,attribute15
4857: FROM oks_bill_sub_line_dtls
4858: WHERE bsl_id = p_bsl_id;
4859:
4860: CURSOR l_btl_csr(p_bcl_id NUMBER, p_old_bsl_id number) IS
4861: SELECT id ,btn_id, bsl_id,bcl_id,

Line 5036: UPDATE oks_bill_sub_line_dtls

5032: RAISE G_EXCEPTION_HALT_VALIDATION;
5033: END IF;
5034:
5035: -------update old bsd amount
5036: UPDATE oks_bill_sub_line_dtls
5037: set amount = nvl(amount,0) - p_new_cp_lvl_tbl(l_index).amount
5038: where id = l_bsd_rec.id;
5039:
5040: IF fnd_log.level_event >= fnd_log.g_current_runtime_level THEN