[Home] [Help]
798:
799: l_from_period_id := cn_api.get_acc_period_id( l_start_date, l_org_id);
800: l_to_period_id := cn_api.get_acc_period_id( l_end_date, l_org_id);
801:
802: UPDATE cn_notify_log_all
803: SET status = 'COMPLETE'
804: WHERE status = 'INCOMPLETE'
805: AND org_id = l_org_id
806: AND period_id between l_from_period_id and l_to_period_id